G
Guest
I need help with a query expression to generate a report. My Access database
generates records on a daily or weekly basis. The program I use runs an
exercise, thens saves records to the database.
I would like to generate a report for that day's record only (not any other
record). The date field in the table is Date/Time formatted. I would like
to exclude the "time" as a Now expression looks at that exact point in time.
I have tried: = Date (), and all variations and nothing works.
Hope I am not confusing and hope someone can help.
Thanks... Keith
generates records on a daily or weekly basis. The program I use runs an
exercise, thens saves records to the database.
I would like to generate a report for that day's record only (not any other
record). The date field in the table is Date/Time formatted. I would like
to exclude the "time" as a Now expression looks at that exact point in time.
I have tried: = Date (), and all variations and nothing works.
Hope I am not confusing and hope someone can help.
Thanks... Keith