I want to limit a query to a maximum date entered..
I would like to say .. where myDateField = max(mydatefield)
How can I use a function like MAX in a where clause or having clause .. I have tried different sytaxes with no luck. Im sure its easy..I am actually using it in Access but figured it was more of an SQL question