Where Condition for dates to print current report!

[cap.zadi]

Hi



Usually use macro at form to print the current transaction via applying the

Where Condition: ="[ID]=" & [ID]

What could be the criteria if to print basted on Date field. "TranDate (Short Date)"

[June7]

You want to print all transactions for selected date? What control is referenced for the date parameter?

="TranDate=#" & [some date] & "#"

[cap.zadi]

Hi,

It is solved by put the date criteria in the query to follow the date field at the form.

The issue was there are many transaction on the same day so the idea was to generate one single report for whole day transactions as TranDate is same and report is already grouped by TranDate.