Using Dates

[Guest]

I have a small Problem I am trying to determine how much Material in weight
that has shipped between 2 dates.

I have created the Query and in the criteria field I can lets say Hard code
the dates but I would like for access to ask me for the dates when the
report is brought up.

any help would be appreciated.

 

[Allen Browne]

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
for 2 ways to do this.

 

[fredg]

I have a small Problem I am trying to determine how much Material in weight
that has shipped between 2 dates.

I have created the Query and in the criteria field I can lets say Hard code
the dates but I would like for access to ask me for the dates when the
report is brought up.

any help would be appreciated.

If your End Date does not include a time of day value, as criteria on
the DateField in the query write:
Between [Enter Start Date] and [Enter End Date]

Note: If your DateField does include a Time value, enter an End Date
of one day later than wanted, i.e. instead of 1/31/2006 enter 2/1/2006
if the ending date wanted is January 31st.
There is a work around for this, but that would be a separate message.
Post back if it pertains to your situation.