pulling reports by date

[Guest]

I recently submitted a question about pulling reports by date. I was
explained to place the entry "date()" in the data source field. I tested this
out and when I enter the date I want to pull a report of. It enters the date
requested but the data was from another date. Can anyone help me with this?

 

[BruceM]

I don't know what specific advice you were given, or just what you need to
do (do you want records from one date or a range of dates, or by today's
date, or what exactly), or what you mean by "data source field". However, I
can tell you that if you base the report on a query, and place something
like [Enter Date], or Between [Start Date] And [End Date] in the criteria
row for your date field, you will be prompted for the dates.

 

[Guest]

I want to pull a specific date in a report. This is what I was explained
Create a new query and bring in the table(s) you want to run the report from.
I assume there is a date field in the table.
In the query - the date column could prompt users for the date you want to
report on.
Add this the criteria row (of the date field column)

[ Enter date of report ]
You can change the wording if you want

Save the query.
Go into the the report and use this new query as the data source (open the
properties box and you will see the data source in the Data Column)

Now when you run a report from you form the user will be asked for the date
before the report prints/views

This is not working, every time I want to pull a report for a specific date.
The date that I enter is entered in the date field.

I don't know what specific advice you were given, or just what you need to
do (do you want records from one date or a range of dates, or by today's
date, or what exactly), or what you mean by "data source field". However, I
can tell you that if you base the report on a query, and place something
like [Enter Date], or Between [Start Date] And [End Date] in the criteria
row for your date field, you will be prompted for the dates.

I recently submitted a question about pulling reports by date. I was
explained to place the entry "date()" in the data source field. I tested
this
out and when I enter the date I want to pull a report of. It enters the
date
requested but the data was from another date. Can anyone help me with
this?

 

[BruceM]

Open the query in design view. In the criteria row for the date field, put
something like [Enter Date]. Write it exactly like that, with the square
brackets. Save the query. Open the query? Are you prompted for a date?
If so, open the report in design view. In the Record Source property,
select the query you just saved. Switch to report view. You should be
prompted for the date.

I want to pull a specific date in a report. This is what I was explained
Create a new query and bring in the table(s) you want to run the report
from.
I assume there is a date field in the table.
In the query - the date column could prompt users for the date you want to
report on.
Add this the criteria row (of the date field column)

[ Enter date of report ]
You can change the wording if you want

Save the query.
Go into the the report and use this new query as the data source (open the
properties box and you will see the data source in the Data Column)

Now when you run a report from you form the user will be asked for the
date
before the report prints/views

This is not working, every time I want to pull a report for a specific
date.
The date that I enter is entered in the date field.

I don't know what specific advice you were given, or just what you need
to
do (do you want records from one date or a range of dates, or by today's
date, or what exactly), or what you mean by "data source field".
However, I
can tell you that if you base the report on a query, and place something
like [Enter Date], or Between [Start Date] And [End Date] in the criteria
row for your date field, you will be prompted for the dates.

I recently submitted a question about pulling reports by date. I was
explained to place the entry "date()" in the data source field. I
tested
this
out and when I enter the date I want to pull a report of. It enters the
date
requested but the data was from another date. Can anyone help me with
this?