trouble creating a formula in access

December 9, 2010 at 13:23:40
Specs: Windows Vista
I need to create a formula in a query of access that subtracts one field from another. Both fields are from the same table. This is what my formula looks like :

Actual Vs. Expected Sales: [Employee Sales Information]![Actual Sales]-[Employee Sales Information]![Expected Sales]

but for some reason this message keeps popping up every time i try to run the query:

'Actual vs. Expected Sales' is not a name. Make sure it does not include any invalid characters or punctuation and that it is not too long.

Unfortunately, i dont know how long is too long for microsoft, and since its only a one step formula im really unsure of what might be wrong with it. Thanks for your help!


See More: trouble creating a formula in access

Report •

#1
December 10, 2010 at 14:27:35
Try changing

Actual Vs. Expected Sales: [Employee Sales Information]![Actual Sales]-[Employee Sales Information]![Expected Sales]

to
Actual_Vs_ Expected_Sales: [Employee Sales Information]![Actual Sales]-[Employee Sales Information]![Expected Sales]

Good luck


Report •
Related Solutions


Ask Question