Question Locked

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

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.