Help with Criteria?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi

I have a report that I want to print off however I need the user to specify
the date of the first part of the report. No problem I can drop a field on
the report =[myDate] and get the user to enter a date. However for the
second part of the report I want it to be headed the next day, now I have
tried to enter a field along the lines of =[myDate]+1 but it doesnt work!
(surprise, surprise). I guess it needs to specify the day part but I'm not
sure how to do it. I have formatted both boxes as short date.

Thanks
 
I have always belived in making my reports flexible.
Create a from with two unbound text boxes. Date 1 and
date2. Inb your report query put
[Forms]![NameOfForm]![NameOfTextbox]

Chris
 
Is it possible to do what I want to do?

Chris Reveille said:
I have always belived in making my reports flexible.
Create a from with two unbound text boxes. Date 1 and
date2. Inb your report query put
[Forms]![NameOfForm]![NameOfTextbox]

Chris
-----Original Message-----
Hi

I have a report that I want to print off however I need the user to specify
the date of the first part of the report. No problem I can drop a field on
the report =[myDate] and get the user to enter a date. However for the
second part of the report I want it to be headed the next day, now I have
tried to enter a field along the lines of =[myDate]+1 but it doesnt work!
(surprise, surprise). I guess it needs to specify the day part but I'm not
sure how to do it. I have formatted both boxes as short date.

Thanks


.
Click to expand...
Click to expand...
 
Dave

It isn't clear from your description if you want a "two-date" report (date1
and date1 + 1), or if you want a report that starts each page with the date
following the preceding page's date (all dates on/after date1).

The solution offered by Chris handles the two-date situation.

If you want all dates on/after a given date, use a criterion in your query,
rather than your report.

--
Good luck

Jeff Boyce
<Access MVP>

Dave said:
Is it possible to do what I want to do?

Chris Reveille said:
I have always belived in making my reports flexible.
Create a from with two unbound text boxes. Date 1 and
date2. Inb your report query put
[Forms]![NameOfForm]![NameOfTextbox]

Chris
-----Original Message-----
Hi

I have a report that I want to print off however I need the user to specify
the date of the first part of the report. No problem I can drop a field on
the report =[myDate] and get the user to enter a date. However for the
second part of the report I want it to be headed the next day, now I have
tried to enter a field along the lines of =[myDate]+1 but it doesnt work!
(surprise, surprise). I guess it needs to specify the day part but I'm not
sure how to do it. I have formatted both boxes as short date.

Thanks


.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top