[AccessD] FW: Query help please

Gustav, sorry, I didn't know about the html thing.  
What you suggested isn't working either.  What happens is that as soon as an
entry is made in tlnkLodgingEvent under any eventId, that seems to knock out
the corresponding record from tblLodging.  i.e. There are records for
Singles and doubles for various events.  Now when I do the outer join query
and want to see all records from an event that only has singles, I get the
singles from tlnklodgingevent, and all records from tblLodging except
doubles.  

I thought about trying to add invoiceno:[forms]![frmEvent]![InvoiceNo] to
the tblLodging query, but when I run it I get a square in the field instead
of the invoice number.

I feel I have to put invoice number on the records that do not have eventids
for the particular event so all lodging types will show up on the subreport.
Maybe I am putting the invoice number on the records at the wrong time.  

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk]
Sent: Tuesday, May 06, 2003 4:14 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] FW: Query help please


Hi Susan

First, if you hadn't used html formatting the two messages could have
been sent as one ...

> ..  But then I found out that if there is no lodging, the report
> still has to show all of the entries in tblLodging.  Also if an
> event has not Singles or doubles, then singles and doubles still
> have to show on the report. .. 

Without going into details, I think what you need is two queries: one
selecting all the lodgins, one selecting those lodgings with
lodgingevents. Then, in a third query, combine these two queries with
an outer join.

/gustav

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com