Test if query returns any results

[itchyII]

Hello All,
I have a query that has criteria which is passed to it from a report. The results of the query are then used in a sub-report which will be shown on the same page of the report where the criteria was taken from. Calculations then take place based on the contents of this sub-report. The problem I have is if the query returns no records, the sub-report is blank and all my calculations show errors. I want to be able to test for results from the query, if there were no records found, I will fill in the appropriate fields with zero's so as to not mess up my calcuations. If possible, I would like to test for this from my sub-form in the 'On Format' event, so I can make any necessary changes there right away before it is passed to the main report.

Access '97

Thanks!

 

[KF]

Have you tried using the HasData property. Search Access help on this property. I think it will do what you want.

KF,