Oh Man, this is crazy.
I just need to add 2 results from expressions into another record in the query and if I do a straight [Field1]+[Field2] I get the result of field1,field2. I have tried the var command in front as this
Total cost per visit: Val([Labour Cost])+Val([BatteryCost])
and get an answer of $0.00 for all instead of the total.
I can not change the format of Labour Cost and BatteryCost as they are expressions "Dlookup" and "iif"
So what else could I try.
Many thanks for any help as I am new to access and so used to excel formulas.
I just need to add 2 results from expressions into another record in the query and if I do a straight [Field1]+[Field2] I get the result of field1,field2. I have tried the var command in front as this
Total cost per visit: Val([Labour Cost])+Val([BatteryCost])
and get an answer of $0.00 for all instead of the total.
I can not change the format of Labour Cost and BatteryCost as they are expressions "Dlookup" and "iif"
So what else could I try.
Many thanks for any help as I am new to access and so used to excel formulas.