How do I creat a Date Range to open Report

26 Feb 2005 1:45 PM

Alvin Smith

I have a report named ( Pay Hours ). How can I open this report based on
start date and end date. Thanks in Advance

26 Feb 2005 2:27 PM

Jonesey

In your Query, you will set your Date field criteria to be:

WHERE (((Table.Date) Between [BeginingDate] And [EndingDate]))

This will prompt the user to enter in a date range, depending on your table
structure it will be something like: mm/dd/yyyy

---

Show quote

"Alvin Smith" wrote:

> I have a report named ( Pay Hours ). How can I open this report based on
> start date and end date. Thanks in Advance

26 Feb 2005 2:49 PM

Alvin Smith

It does promt for na bigining and ending date but not in mm/dd/yyyy
Format. Also I was wanting to open it with a form type begining and ending
date. My Query has all calculations needed for the report and only Pay Hours
Table is needed for that info as well. What I am saying is the query and Pay
Hours Table have all the info I need for the report. Thanks for the quik
response

Show quote

"Jonesey" wrote:

> In your Query, you will set your Date field criteria to be:
>
> WHERE (((Table.Date) Between [BeginingDate] And [EndingDate]))
>
> This will prompt the user to enter in a date range, depending on your table
> structure it will be something like: mm/dd/yyyy
>
> ---
>
> "Alvin Smith" wrote:
>
> > I have a report named ( Pay Hours ). How can I open this report based on
> > start date and end date. Thanks in Advance

26 Feb 2005 3:01 PM

Alvin Smith

If I use the formula like this
WHERE (((Pay Hours.BillingDate) Between [BeginingDate] And [EndingDate]))
It says Undefined function 'Where' in Expression

But if I use it like this
[Pay Hours].[BillingDate] Between [BeginingDate] And [EndingDate]
It has no input mask
I am Lost but will get it "lol"
Show quote

"Alvin Smith" wrote:

> It does promt for na bigining and ending date but not in mm/dd/yyyy
> Format. Also I was wanting to open it with a form type begining and ending
> date. My Query has all calculations needed for the report and only Pay Hours
> Table is needed for that info as well. What I am saying is the query and Pay
> Hours Table have all the info I need for the report. Thanks for the quik
> response
>
> "Jonesey" wrote:
>
> > In your Query, you will set your Date field criteria to be:
> >
> > WHERE (((Table.Date) Between [BeginingDate] And [EndingDate]))
> >
> > This will prompt the user to enter in a date range, depending on your table
> > structure it will be something like: mm/dd/yyyy
> >
> > ---
> >
> > "Alvin Smith" wrote:
> >
> > > I have a report named ( Pay Hours ). How can I open this report based on
> > > start date and end date. Thanks in Advance