Question about date ranges on a report...

[Guest]

I'm following instructions from a thread I found here, which I've posted
below. I'm having trouble with one step:

Where is the query date field??

 

[fredg]

I'm following instructions from a thread I found here, which I've posted
below. I'm having trouble with one step:


Where is the query date field??

In the query that is used as the record source for the report.

Open the report in Design View.
Display the report's property sheet. Click on the Data tab.
The first property is the RecordSource property. If the RecordSource
is a query (as it should be), click on the little button with 3 dots
that appears on that line.
The Query grid will open.
As criteria for the Date field column (I have no way of knowing what
the name of your actual date field is), write:

Between forms!ParamForm!StartDate and forms!ParamForm!EndDate

Save the changes.

 

[Guest]

thank you so much for your response!!

however, i did that and when i went to close the recordsource, it asked if i
wanted to save the new query. i did - not sure if that has anything to do
with the error i'm getting.

the error is that when i put in the date ranges, it tells me that there's no
data for the report and it cancels the report. what did i do wrong?

 

[Guest]

It's also telling me:

The specified field “days and times†could refer to more than one table
listed in the FROM clause of your SQL statement.

Not sure what that means or how to fix it...

 

[fredg]

thank you so much for your response!!

however, i did that and when i went to close the recordsource, it asked if i
wanted to save the new query. i did - not sure if that has anything to do
with the error i'm getting.

the error is that when i put in the date ranges, it tells me that there's no
data for the report and it cancels the report. what did i do wrong?

You'll need to copy the query SQL and paste it into a reply message.
In addition, indicate what dates you have entered in the form
controls, as well as an example of what you know is a valid date that
should have been returned.

Note: If the date field contains a time value, a parameter entry of
5/8/2007 to 5/9/2007 will not return entries on 5/9/2007 as 5/9/2007
12:15 PM is later than 5/9/2007 midnight. In this instance you must
add 1 day to the range, i.e. 5/8/2007 to 5/10/2007.

 

[fredg]

It's also telling me:

The specified field ´days and times¡ could refer to more than one table
listed in the FROM clause of your SQL statement.

Not sure what that means or how to fix it...

Evidently you have a field named [Days and Times] which is available
in more than one table in the query. You'll need to set the table name
to whichever table's [Days and Times] field you wish to use in the
query.
In the query design view grid, it's the second row drop-down in the
[Days and Times] column.