Link to home
Start Free TrialLog in
Avatar of Mike Rudolph
Mike RudolphFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike Rudolph

ASKER

Pat,

Worked like a charm! Thanks!
Great.  Which method did you use?
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.