Tried scouring the forums for threads similar to mine but couldn’t really find anything that would lead me in the right direction. Basically I have a table that has the QA scores for each of the 10 regions and I am trying to populate a text box with a specific region’s score depending on the month. I was trying to
Tag: ms-access-2010
Access Run Time Error 3464 data type mismatch in criteria expression
What is wrong with that code? I can’t figure out why I keep getting this error. Answer Wouldn’t MovieId be a numeric? If so, no quotes:
Access 2010 Issues with “IS NULL” in Select statement [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed 5 years ago. Improve this question
How to create Multiple-field foreign key in Access?
I have found this tutorial, which says that question can be solved this way: Multiple-field constraint: For my simplified database: I wrote such sql code, which has an idea to connect 2 columns from 2 tables. In addition, I would like to add unique constraint on 2 field of S2T table: But I get an error, saying that I have