469,126 Members | 1,331 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

Query Mystery

418 256MB
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
7 1160
1,287 Expert 1GB
What do you mean by "stops working"? No records returned, an error, crashes your computer?
May 4 '09 #2
418 256MB
Well, I got no records.
May 4 '09 #3
1,287 Expert 1GB
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
418 256MB

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
1,287 Expert 1GB
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
418 256MB

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
32,161 Expert Mod 16PB
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.

Similar topics

3 posts views Thread by Red | last post: by
115 posts views Thread by Mark Shelor | last post: by
2 posts views Thread by David | last post: by
4 posts views Thread by Lauren Quantrell | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.