General discussion
May 14, 2004 at 01:13 PM
redolph

Access: condit macro if query null

by redolph . Updated 22 years, 4 months ago

I’ve got a query that sends multiple error “reports”, which are really queries listing exceptions.

I am trying to use the condition portion of the macro to skip the “sendobject” of sending the contents of a query by email, if the query yields no records.

Does anyone know the proper syntax for this?

I was thinking of something like “[Query]![Query1] is null”, but it doesn’t like that.

Thanks!

This discussion is locked

All Comments