Mike Rudolph
asked on
How do I reference another table's field value in MS Access query?
Dear Experts!
Please see attached file. What is the proper syntax for referencing a field from a different table in my query? The query works great when I type a date in manually but when I reference a field it does not.
Thanks!
screenshots.pdf
Please see attached file. What is the proper syntax for referencing a field from a different table in my query? The query works great when I type a date in manually but when I reference a field it does not.
Thanks!
screenshots.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Great. Which method did you use?
ASKER
I just changed the sign in SQL it was easy enough.
Thanks. It is always good to clarify which solution worked for you when more than one is offered. That helps people who find the thread later.
ASKER
Worked like a charm! Thanks!