HOW DO I HAVE ACCESS QUE ON DATE RANGE FOR A REPORT

[Guest]

TRYING TO WRITE A REPORT THAT IS DATE RANGE SENSITIVE. HOW DO I HAVE ACCESS
ASK FOR THE DATE RANGE BEFORE RUNNING THE REPORT.

 

[Rick B]

First, please turn off your caps lock. It is unprofessional and considered
SHOUTING.

In the query, upon which your report is based, put something like the
following in the "criteria" for your date field...


Between [Enter Start Date] and [Enter Stop Date]

 

[fredg]

TRYING TO WRITE A REPORT THAT IS DATE RANGE SENSITIVE. HOW DO I HAVE ACCESS
ASK FOR THE DATE RANGE BEFORE RUNNING THE REPORT.

Please do not post messages using all caps.
Beside being more difficult to read, posting in all caps is considered
shouting and is rude. None of us like to be shouted at.

Please read the Netiquette at
http://www.mvps.org/access
for more information about how to successfully get answers when
posting to newsgroups.
It's a great Access asset to visit anyway.

To answer your question, here is one way:
Create a query that will become the report's record source.
As criteria in the query, write on the DateField's criteria line:

Between [Start Date] and [End Date]

When you open the report you will be prompted for the beginning and
ending dates.

 

[Guest]

Sorry for the CAPS all of programs are caps.

I know just enough to get myself confusted (as I am sure you can tell). I
have a very basic table: Date, Job #, Bay, Emp #, Hrs

I need a basic report where I can sort by date / job / bay and total hrs by
job.

Just cant seem to get there.

Any help will surely be appreciated.

Thanks Kathy

First, please turn off your caps lock. It is unprofessional and considered
SHOUTING.

In the query, upon which your report is based, put something like the
following in the "criteria" for your date field...


Between [Enter Start Date] and [Enter Stop Date]



--
Rick B

TRYING TO WRITE A REPORT THAT IS DATE RANGE SENSITIVE. HOW DO I HAVE
ACCESS
ASK FOR THE DATE RANGE BEFORE RUNNING THE REPORT.

 

[fredg]

Sorry for the CAPS all of programs are caps.

I know just enough to get myself confusted (as I am sure you can tell). I
have a very basic table: Date, Job #, Bay, Emp #, Hrs

I need a basic report where I can sort by date / job / bay and total hrs by
job.

Just cant seem to get there.

Any help will surely be appreciated.

Thanks Kathy

First, please turn off your caps lock. It is unprofessional and considered
SHOUTING.

In the query, upon which your report is based, put something like the
following in the "criteria" for your date field...

Between [Enter Start Date] and [Enter Stop Date]

--
Rick B

TRYING TO WRITE A REPORT THAT IS DATE RANGE SENSITIVE. HOW DO I HAVE
ACCESS
ASK FOR THE DATE RANGE BEFORE RUNNING THE REPORT.

I answered your question earlier, but I would like to call to your
attention that the use of the word "Date" as a field name iand using
it may lead to unforeseen problems.

Date is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'