date function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
What is the SQL view of your query?
What is the exact message in the box that keeps popping up?
 
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
 
Where have you entered Between....? Did you enter this into the filter
property? Is it the control source of a text box?
 
A control source would expect something like:
="Between 6/30/2005 and 12/31/2005"
or
="Between " & Min([DateField]) & " And " & Max([DateField])
 
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...
 
Back
Top