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

By andy ·
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.

TableDateVariable >= TodaysDate

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums