Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Select query not pulling correct results
RESOLVED - For some reason, the select query did not like that fact that [tblConentImport].[Code] for anything with [tblConentImport].[Type] = "Class" was blank. I updated the Import and main table with a value in that field. After doing this the query works. Thank you for all of your help.- turnerbk
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Select query not pulling correct results
Thank you all for your help. I'm going to populate the code fields for type = class. Those are the only records that have no data in the code field. If that doesn't work, I will try to eliminate the code field from the query altogether. Thank you for all of you help. I'll let you know how...- turnerbk
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Select query not pulling correct results
I am new to this forum. I hoping someone can help me. I’m at the end of my rope and completely frustrated. I have two tables. Table one - tblContent Table two - tblConentImport I have built a select query that will identify all records that from the tblConentImport table that do not...- turnerbk
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
