#Error in calculation query

Shawny

Registered User.
Local time
Today, 14:21
Joined
Apr 15, 2000
Messages
64
I have calculations in a query. If I open the query without putting in all the data that the calculation needs to do it's thing, the calculated fields say #Error. I would like them not to do that.
Erin
 
You say you would like 'them' not to do that. If you are talking about the calculations there is not a lot you can do, but if you are talking about the user running the query before they have enter the required data then you will need to check to be sure that the required fields are filled in before you allow the query to be run.

A little more detail will help us to help you solve your problem...
 
If you want the field to not return #Error, then all you can really do is plan for and address that error... i.e. missing information or invalid parameters, etc.
 

Users who are viewing this thread

Back
Top Bottom