I'm banging my head on the desk right now because I can't seem to make a valid expression and I can't find one through all the junk on the internet either. I'm new to the whole access thing and basically learning as I go. I know this is going to be an easy one for someone...

I need an expression that I can put in a query field criteria. It needs to "filter" through the data and the output should be any date that is greater than or equal to the current date.

the field that will be filtering from is from a table with date format of 22-Dec-07

Please help.

try a expression such as

>=12/22/07
or the reverse
<=12/22/07

in the filter field of the query

try a expression such as

>=12/22/07
or the reverse
<=12/22/07

in the filter field of the query


I get an error???

I think my table fields are jacked

You should be entering that in the criteria field below the date.

I've never seen anyone do a query like that before... you've already lost me. Sorry

I ended up with the expression:

<=Date()