report wont open - error 3071

[BJF]

Hi,

When I run my report which incorporates a parameter query asking for start date and end date, i get the following:

error 3071: expression is too complex / can not be evaluated / typed incorrectly

My report is based on 5 tables. It seems if one of the tables is missing information that is needed for a calculation on the report within my specified date range, I receive the error, otherwise, the report works fine. Is this normal or am i doing something wrong?

I'd prefer that the report run no matter what within the date range specified (parameter query) and just not do calculation on records with missing info.

Please help!!

Thanks, Brian

 

[Alansidman]

Brian;
Suggest you create a query to gather all the information you want from your five tables. Use the query as the recordsource for your report.

Alan

 

[BJF]

Hi Alan,

thanks for responding. I forgot to mention in my original post - I am using a query for the recordsource of the report, and if i run the query standalone it works fine, the problem seems to be occurring in the design of the report which is preventing the report from opening if query info is missing. Very strange.

Brian

 

[Alansidman]

Are you able to post a copy of your db. Run a compact and Repair. Zip it and remove any confidential information. Difficult to determine the issue.

One thought before you do the above. If you are doing calcs in your query. Try employing the NZ function to tell Access what to do if you have a null record or field.

Look here for syntax

http://www.techonthenet.com/access/functions/advanced/nz.php

Alan