Reporting records whose subscription wil expire

[Kathy Webster]

I would like to have a query open and stay open if it returns any records,
but close if matching records is zero.

I created a query to report customers whose subscription is getting ready to
expire
[ExpirationDate] between Date() and Date()+30.

I put it in an autoexec macro, so that upon opening the database, it opens.
But if no one's subscription is ready to expire, I'd rather not see the
query.

TIA,
Kathy

 

[Steve Schapel]

Kathy,

Put the equivalent of this in the Condition of the macro...
DCount("*","YourQuery")>0

 

[Kathy Webster]

Perfect! Thank you!!!

Kathy,

Put the equivalent of this in the Condition of the macro...
DCount("*","YourQuery")>0

--
Steve Schapel, Microsoft Access MVP

I would like to have a query open and stay open if it returns any
records, but close if matching records is zero.

I created a query to report customers whose subscription is getting ready
to expire
[ExpirationDate] between Date() and Date()+30.

I put it in an autoexec macro, so that upon opening the database, it
opens.
But if no one's subscription is ready to expire, I'd rather not see the
query.

TIA,
Kathy