[AccessD] sql help please

Steve,

Thank you for all the time you put into this. You know a sql
statement is too big if the creator does not fully
understand it all.

For brevity I removed the sql statement but please see my
comments in line.

Joe Hecht
jmhecht at earthlink.net
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Steve Erbach
Sent: Sunday, February 05, 2006 9:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] sql help please



I noticed that the MyAccidnetRecordNumber field contained in
4 different tables is misspelled.  Do you get Access query
prompts when you run this query asking you to enter a value
for MyAccidnetRecordNumber?  If that's the case, then it
looks to me like the misspelling is the problem.

[Joe Hecht] Are you saying that I spelled them differently
in each table? Big Dumb for me. I am not getting any prompts
for the query.


I noticed that the clause (M.DRIV_NUM = A.DRIV_NUM) is shown
twice at the end. 

[Joe Hecht] How did I do that? I work almost exclusively in
design mode. Are you able to see what is causing that? I
sure did not type that.

The table joins look straightforward enough.

[Joe Hecht] Some of the join issues you wrote look wrong to
me. (The joins, not your comments.)


I see that there are no fields SELECTed from the
20_stblAIPaidExpences
Table


 [Joe Hecht] I had not gotten around to dropping them in.

Hope this helps.
[Joe Hecht] 
It does. Thank you. I am going to try your query or rebuild
this beast up from multiple queries.

Thanks again,

Joe