Report won't open - run-time 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

 

[boblarson]

Post the SQL of the query for the report so we can analyze it.

 

[BJF]

Hi Bob-

I find that the problem lies in the report design, not in the sql. It seems I am doing a couple of very complex calculations on the report itself, setting the control source for one field in particular that is getting stuck without the proper data and preventing my report from opening; when i delete this field and its corresponding subtotalling field, the report opens all the time.

Is it wrong logic to try and do calculations on the report field instead of beforehand in the query?

I do NOT have formal Access training, and definitely believe i have approached this report unconventionally.

Do you still want to see the sql?

Thanks for any suggestions,

Brian

 

[boblarson]

So then post both the SQL here and the formula you were using for your calculation in the control's control source.