I apologize, I have been away from my DB and learning access for a couple of months, so its possible I have already asked this in the past, but I could not find it when searching for a solution.
Basic query with calculated field, trying to see the difference between total spend and budgeted amount. and when the query is run is asks for a parameter value.
when I click "OK" with no parameter it runs as wanted, but how do I keep it from asking for a parameter?
(as a side note, I did follow the ? and understand that the problem is likely that I have an expression: (Bdiff) but found no explanation of why that is the problem or how to overcome it)