Diary report

[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.

 

[Brendan Reynolds]

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.

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.

 

[Evi]

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

 

[RitchieJHicks]

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!

 

[Evi]

In that case it's even easier.You could
<=Date()
in your criteria row
Evi