Question

Locked

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.

Criteria:
TableDateVariable >= TodaysDate

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums