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

Query Mystery

100+
P: 418
I have a query that's built on 3 tables - and it works just fine but when I add a couple of more tables it stops working. I know this is not enough info to give me a suggestion. However, I am not sure how much detailed info is needed to get this resolved.

Any suggestions?
May 4 '09 #1
Share this Question
Share on Google+
7 Replies


Expert 100+
P: 1,287
What do you mean by "stops working"? No records returned, an error, crashes your computer?
May 4 '09 #2

100+
P: 418
Well, I got no records.
May 4 '09 #3

Expert 100+
P: 1,287
I assume that when you say "add a couple more tables" that you mean join with other tables on certain fields. Your best bet is to include one additional join at a time and observe the resulting records so that you can see exactly where you are eliminating all the records. You should be able to narrow it down to a particular field that is not Joining as you expect.
May 4 '09 #4

100+
P: 418
ChipR

Thanks. Yes, I identified the table and the field. But here is my problem, if I exclude that table, I cannot get one field to display that only exists in that table. Let me explain.

tblGrants has GrantID (PK auto) and GrantNo and GrantTitle. Total 3 fields. If I cannot join this table I have no other table that includes GrantNo or GrantTitle.

Does it make sense what I am trying to accomplish? Thanks for your help.
May 4 '09 #5

Expert 100+
P: 1,287
I'm not sure exactly what you are trying to do, but I understand the need to include that table. The question is, Which field are you joining on, and why isn't it returning any records?
May 4 '09 #6

100+
P: 418
ChipR:

I solved it by creating a new query based on two other queries.

I have a new problem though. This time with the report. Thanks for your time.
May 4 '09 #7

NeoPa
Expert Mod 15k+
P: 31,709
If you're still interested it may be an idea to post the SQL of the query before any attempt to add tblGrants, then specify which field(s) should be used to link it in. That way we could better understand what the problem is we need to look at.
May 7 '09 #8

Post your reply

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