Table Date as Query Criteria

[brahmabull525]

I have a table in Access called "Info" which contains a field called "Date". I would like run a query off a separate table that uses the Max value in the Info table Date field, using criteria "Between [MaxValueofDateinInfo] and Date()". Obviously, I'm struggling with what should be used in place of the [MaxValueofDateinInfo] part.

Any and all help is most appreciated.

Thanks!

 

[PHV]

Why not simply this ?
Between (SELECT Max(Info.Date) FROM Info) And Date()
Or this ?
Between DMax("[Date]","Info") And Date()

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SJMcAbney]

Also, Date is not a recommended name for a field as it is a resereved word (the function of the same name).

A list of reserved words can be found here.



Stewart J. McAbney | Talk History

 

[brahmabull525]

PH - Thanks for the help, that's exactly what I needed!

Stewart - I agree with your statement. The actual names I'm using aren't "Info" and "Date", I just wanted to use the easiest, understandable terms to make my post as clear as possible.

Thanks to you both for responding.