How to add the datefield to a query?

[Fspinelli]

Hi again!

I inserted a date/time field on my form so the current date (and time) shows up when a data entry screen opens.

I have that form based off of a query.

I need to run that query based on the current date, only show that data for the current date (day) but be able to refer back to it another day if need be. The time doesn't need to be there, just today's date.

I know how to create a date field and pick a format, but how do I use the inserted date/time field Access gives you?

Thank you very much!

Kind regards,
Faith

[nico5038]

I would sort the (sub?) form on a descending date, thus the current dat will in general show first.

Another option is to set the Me.filter property of the form and add a button to remove it.
Keep in mind that after setting the Me.Filter the Me.FilterOn must be set to "True" !

Nic;o)

[Fspinelli]

Thanks Nico, but never mind. It would be silly for me to do that (considering what my office needs). But I really apprecaite the assistance!