Klos, Susan
Susan.Klos at fldoe.org
Tue May 6 13:50:21 CDT 2003
I am breaking this into two messages as it was too long for one. I have a query that will build a subreport. I have asked about this before but I am having to come at it from a different tack. I feel like if I can get the query right, I can get the subreport. tblLodging LodgingID PK LodgingID Type DRate NDRate Ordr 1 Single $45.75 $50.00 1 2 Double $29.75 $35.00 2 3 Triple $21.34 $25.33 3 4 Quadruple $17.50 $20.50 4 5 Cabin $18.00 $21.00 5 7 Cabin/Staff $20.00 $26.00 7 9 R/V $20.50 $20.50 8 10 Tent $10.00 $10.25 9 tlnklodgingEvent EventID FK to tblEvent Facility PK EventID Facility LodgingID NoUnits Guests NoNights CostPerUnit total LodgingDate 9456 88 1 1 1 1 $45.75 $45.75 3/31/2003 9457 89 1 5 5 1 $45.75 $228.75 4/ 1/2003 9457 90 2 12 24 1 $29.75 $714.00 4/ 1/2003 9458 94 2 2 2 1 $29.75 $59.50 3/31/2003 9461 95 1 8 8 1 $50.00 $400.00 12/ 9/2002 9461 96 1 9 9 1 $50.00 $450.00 12/10/2002 9461 97 1 6 6 1 $50.00 $300.00 12/11/2002 9461 98 2 11 22 1 $35.00 $770.00 12/ 9/2002 9461 99 2 11 22 1 $35.00 $770.00 12/10/2002 9461 100 2 15 30 1 $35.00 $1,050.00 12/11/2002 9461 101 2 1 2 1 $35.00 $70.00 12/12/2002 9462 102 1 13 13 2 $50.00 $1,300.00 2/11/2003 I need to create a query that will for any event show all the records from tlnklodgingEvent and all records from tblLodging that are not used in tlnklodgingEvent [Klos, Susan] Example and rest of message follows. Please stay with me. Thanks. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030506/17c54ee8/attachment.html>