Report filtered by dates question

T

TonyB

Hi,
I want to filter a report between dates. I'm using an approach suggested
from a ng search, where I create a simple unbound form to enter the dates.
The dates are referenced in a query criteria field, and the report is based
upon the query.
This works well but I want to add two things.
First if there are no records fitting this criteria, I would prefer to to
display a msgbox and not open the report.
Second if the start/endates are not entered, to list all records, or if one
date entered, report records from that date to todays date.
I can't see how to do this using this form/query/report approach ? Is this
possible ?
Regards
TonyB
 
T

TonyB

Hi,
Since posting I realised that I could do the date checking stuff in vba
using the Open Report cmdbutton click event on the filter form.
This leaves the problem of how to find out that when I click the Open Report
cmdbutton on the filterform that it is not going to return any records with
the dates selected ?
Thanks
tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top