Access newbie

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

Hi all,

I'm sure my question is simple but I'm new to access and I'm having trouble
figuring it out. I'm using Access 20002. I created a report of all calls
logged into the database. Now I'd like to be prompted to enter 2 dates,
calls received between mm/dd/yy and mm/dd/yy. Where would I create
something to give the user the ability to enter the dates?

Thanks in advance,
Deb
 
The way I would do this is to build a query, and then build the report from that query instead of from tables. In the query, include all the fields you want to show up in the report. Also include the date. In the criteria row under date, put:

Between [Start Date] And [End Date]

If you build the form off of this query, when the user opens the form, he will get a prompt for start date, and another prompt to enter the end of the date range. The square brackets show that it is a prompt. Whatever you type between the brackets is what the user will see when the prompt comes up.
 
I think the easiest would be to base your report on a
query and enter the "=>[Enter Start Date]" and "=<[End
Date]" in the criteria block for the respective dates in
the query (without the dbl quotes). This way each time
the report is ran, the user will be promted to enter the
start and end dates (inclusive) for the report.
Hope this helps.
Fons
 
Thanks to both... this was exactly what I wanted.


Fons Ponsioen said:
I think the easiest would be to base your report on a
query and enter the "=>[Enter Start Date]" and "=<[End
Date]" in the criteria block for the respective dates in
the query (without the dbl quotes). This way each time
the report is ran, the user will be promted to enter the
start and end dates (inclusive) for the report.
Hope this helps.
Fons
-----Original Message-----
Hi all,

I'm sure my question is simple but I'm new to access and I'm having trouble
figuring it out. I'm using Access 20002. I created a report of all calls
logged into the database. Now I'd like to be prompted to enter 2 dates,
calls received between mm/dd/yy and mm/dd/yy. Where would I create
something to give the user the ability to enter the dates?

Thanks in advance,
Deb


.
Click to expand...
Click to expand...
 
Back
Top