date function

I

I.Candi

I'm having the darndest time compiling a report that only shows those
projects with "Date Requested" (which is a field in the report) between
"6/30/2005" and "12/31/2005". I've tried

Between #6/30/2005# and #12/31/2005# but that 'enter paramter' box keeps
popping up.

I used = between #6/30/2005# & #12/31/2005# and that doesn't work either.

Help!
 
D

Duane Hookom

What is the SQL view of your query?
What is the exact message in the box that keeps popping up?
 
I

I.Candi

SQL view?
I'm trying to enter this info directly into the design view of the report.
Should I be using the query I've run with the same parameters? It works
beautifully by the way. If so, how do I use the query to make the report.

By the by:
The message box (as soon as I click the print preview button) just says
Enter Parameter value
Between 6/30/2005 and 12/31/2005
 
D

Duane Hookom

Where have you entered Between....? Did you enter this into the filter
property? Is it the control source of a text box?
 
D

Duane Hookom

A control source would expect something like:
="Between 6/30/2005 and 12/31/2005"
or
="Between " & Min([DateField]) & " And " & Max([DateField])
 
I

I.Candi

Sorry for never getting back to you. I just decided to use a query and create
a report from there. Thanks for your help!

Duane Hookom said:
A control source would expect something like:
="Between 6/30/2005 and 12/31/2005"
or
="Between " & Min([DateField]) & " And " & Max([DateField])

--
Duane Hookom
MS Access MVP
--

I.Candi said:
Control source of a text box in the report.
Click to expand...
Click to expand...
 
Top