Question
September 11, 2007 at 10:25 AM
andy

MS Access/Excel Query won’t take variable as criteria

by andy . Updated 19 years, 1 month ago

I am trying to limit the imported data from an access table to the current day. The query wizard won’t take a variable or indirect reference. When I build the statement in MS Query it won’t take globals or system reference, only literals seem to work.

Criteria:
TableDateVariable >= TodaysDate

This discussion is locked

All Comments