make query with max[appdate]

[Bullsandbears123]

I have a table, e.g.
mytable

[appdate] [info]
1/12/2004 231
1/12/2004 466
1/12/2004 465
1/11/2004 888
1/11/2004 817
1/10/2004 324
etc. etc.


I need
myquery
[appdate] [info]
1/12/2004 231
1/12/2004 466
1/12/2004 465

I need to query all data from the maxium date. How would I do this.
I tried
SELECT mytable.* FROM mytable WHERE mytable!appdate=Max([appdate]);

but it does not work , Any ideas?

 

[Blorf]

Try this:

SELECT Mytable.Appdate, Mytable.Info
FROM Mytable
WHERE (((Mytable.Appdate)=DMax("Appdate","Mytable&quot));


Ascii dumb question, get a dumb Ansi

 

[Bullsandbears123]

thanks