By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Joined query - table with incorrect results

P: 1
I have a query that pulls specific records based on two different fields, a "Grouper #" and a "Center #".
The query pulls the data perfectly.
I have a second query that I reference query 1 in to match data in a large table and report the outcome.
While the second query pulls the correct data (Grouper # and Center #), it also pulls other Groupers with the specified center numbers.
In the second query, I link the Center numbers in both, I tried linking the Groupers in both as well as the Center numbers in both but that actually left data out.
Any suggestions? I'm fairly new to Access and everything I know is self taught or Googled.
The Grouper numbers begin with either an 8 or a 9. I can add a 'Not Like 8*' command but that would seem to be an unnecessary step since my first query pulls accuratly.
Mar 30 '17 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,419
Perhaps some example data we could use to try to determine what you mean would be helpful.
Apr 2 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.