#Error in calculation query (1 Viewer)

[Shawny]

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

 

[Jack Cowley]

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

 

[jatfill]

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.