Search results

I have the two tables in access, and they're linked via account number, I've applied a query to return all data from table X and acc nu on Table Y so i can now filter out the data, but is there a way to ONLY return the data where acc number match? Thank you btw - very comprehensive reply :)

Thanks both. I'll give these a whirl

Hey all, and apologies if this sounds very 'basic'--I'm new to my access journey! I have one VERY large database in Access already (over 2mill rowsx 140 columns), and a smaller CSV file. Is there a way of opening both in access and then doing essentially a Vlookup to retrieve accounts found in...