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...