Search results

Thanks for your help, but I have decided to go a different route and validate the data match on entry into the table. This negates the issue with the query. Thanks again.

Sorry...I was reading your reply on my phone and mis-read the entire sentence structure. Is this what you mean by "data"? DataFile.Year1 = 2013,2012,2011,2010 tblBLS.BLSYear = 2012,2011,2010 tblBLS.TCIR = 2.8, 2.9, 0.8, 3.2,1.7 tblBLS.NACIS=111,112,113,115,213,238,252 DataFile.NAICS = 11193...

Maybe try this, since this is a text field? WHERE (((unwanted_Emails.Company)="")); Hope it helps. :o

The query should take the input from the user on the "reports" form combo box (contractor name), compare Year1, Year2 and Year3 as well as the first three numbers of the NAICS code in the DataFile (by contractor name) to the BLSYear and first three numbers of the NAICS code in the tblBLS table...

How about I just attach the whole bloody thing? Here it is...none of this stuff is confidential (I just made up the data in the tables to have stuff to play with). Sorry...forgot to mention that I'm working in A2007. Any help would be greatly appreciated....thank you. :D

Ok, I’m lost. I have been working on this for over a week and can’t find the solution or figure it out. :banghead: I have three queries built from two unrelated tables (DataFile and tblBLS). DataFile: ContractorName NAICS Year1 Year2 Year3 tblBLS: NAICS BLSYear (this includes 4 years of data...

Former programmer who hasn't written a line of code in over 20 years! Please be patient...Thanks. :D