Diary report

  • Thread starter Thread starter RitchieJHicks
  • Start date Start date
R

RitchieJHicks

Hi,

I am not overly confident in reports/querys. I have a field in my
application called "Next Diary Date". I wish to run a report which will show
a list of all records which have a diary date of today and previous to today.
I do not want the report to show any records which have a date set tomorrow
onwards.

Could anyone offer me some advice on this please?

Regards,
Ritchie.
 
RitchieJHicks said:
Hi,

I am not overly confident in reports/querys. I have a field in my
application called "Next Diary Date". I wish to run a report which will
show
a list of all records which have a diary date of today and previous to
today.
I do not want the report to show any records which have a date set
tomorrow
onwards.

Could anyone offer me some advice on this please?

Regards,
Ritchie.
Click to expand...


SELECT * FROM YourTableNameHere WHERE [Next Diary Date] < Date + 1

In query design view, you would enter < Date + 1 in the Criteria row in the
Next Diary Date column.
 
Phew, one which makes sense!

In the query on which the report is based, under the date field put the
criteria

Between Date() And (Date()-1)

Evi
 
Thank you Evi. Super duper. Only thing was that I wanted to show all days in
the past not just yesterday, so I just changed the -1 to -15000.

Thanks!
 
Back
Top