LIVE / WHIRLED - the acoustic music series at Perishable Theatre Presents: Brazil-Whirled A traditional roda da choro from Rio de Janeiro with special guest artists: Judy Handler & Mark Levesque - guitars & bandolim and Tom Rohde - solo guitar Following short sets by the featured artists, the performance will continue as a traditional "roda da choro" (circle of choro)-- a jam session

Are you sure neither of the join columns contains a Null? -Dorian "Bill.Carlson" wrote: On Aug 27, 2:27 pm, "Carl Rapson" <mr.mxyzp...@newsgroups.nospam> wrote: "Bill.Carlson" <Bi...@CarlsonCpa.com> wrote in message news:1188246671.428725.41420@x40g2000prg.googlegroups.com... Access 2007, I've created the following query from

"Bill.Carlson" <BillC@CarlsonCpa.com> wrote in message news:1188246671.428725.41420@x40g2000prg.googlegroups.com... Access 2007, I've created the following query from two tables: SELECT tblTrnsctn.TxnDate, tblTrnsctn.Amount, tblCoa.AcntNmbr, tblCoa.AcntDscriptn, tblCoa.LeadSheet, tblCoa.qbListID FROM tblTrnsctn LEFT JOIN tblCoa ON tblTrnsctn.AccountRefListID = tblCoa.qbListID

Hi Jos Thank you for your answer. I will check it out and write you if it worked out. Thanks so much in any case!! Grreets Reto "Jos Geluk" <skeltzer@casema.invalid> schrieb im Newsbeitrag news:456755e4$0$64793$dbd43001@news.wanadoo.nl... REAN schreef: Wow! Thank you so much man! For the translation and the great answer! I have another Question