|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!