Reporting records whose subscription wil expire

  • Thread starter Thread starter Kathy Webster
  • Start date Start date
K

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
 
Kathy,

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

Steve Schapel said:
Kathy,

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

--
Steve Schapel, Microsoft Access MVP

Kathy said:
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
Click to expand...
Click to expand...
 
Back
Top