Queries that return no records

[b_karv]

Hi All,

I am wandering if it possible to check programatically whether a query returns a NULL result?

I am writing a program(VB) that involves an IFF statement where if there are records in the query it does a specific calculation & if there are no records returned in the query it does something else. Is this possible to achieve?

Thanks in advance

Cheers,

Karv

 

[neileg]

Use DCount() to count the number of records.

 

[b_karv]

Thanks mate, it seems exactly what I was looking for!!!