By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,622 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Foreign key queries

P: 11
I am currently running Access 2003 on Windows XP. I am doing a database of office files which require two foreign key fields: status and location. Each one is referred to by two other tables: Boxes and files. Files can be boxed or loose (on someone's desk or otherwise free).

I am currently working with the system viz the Box table. When I set up the two lookups, one of them ends up stored as a number (the status FK) but the other (location) gets stored as a text string (location description).

When I try to do a query on the status field (which is being stored as a number) and try to request the items with a value (criteria) of 2 (with or without quotes) it gives me the error message "type mismatch in expression"
Aug 15 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,392
Post the SQL string you're using.
Aug 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.