Today's Results

[Mik3]

Hi,
Is it possible to filter data in a report?
I need to show results of today's date. The results are sorted by Date, however I would like to show only the trasactions which happened today.

Thanks,


Mike

 

[Mark Wild]

Try customising this and placing it under the button you use to open to open the report

Dim strCriteria As String
Dim strDoc As String

strDoc = "RptName"
strCriteria = "[datefield]="& date

DoCmd.OpenReport strDoc, acViewPreview, , strCriteria
DoCmd.Maximize

This allows you to use the report in a number of ways. If the report is just used for the one purpose, you could also just type date() as the criteria in the date column of the underlying query.

 

[Mik3]

I already tried putting Date() in the criteria of the query, but I get an error: "expression typed incorrectly or too complex..."

 

[Mark Wild]

On the button, try changing the criteria to

strCriteria="[datefield]=date()"