<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<META content="MSHTML 5.00.3502.4856" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff size=2><SPAN class=578524918-06052003>I am breaking
this into two messages as it was too long for one.</SPAN></FONT></DIV>
<DIV align=left class=OutlookMessageHeader dir=ltr> </DIV>
<DIV><FONT size=2><SPAN class=984463817-06052003>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.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=984463817-06052003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=984463817-06052003>tblLodging</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=984463817-06052003>
<TABLE bgColor=#ffffff border=1 cellSpacing=0><FONT size=2>
<CAPTION>LodgingID PK</CAPTION></FONT>
<THEAD>
<TR>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>LodgingID</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>Type</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>DRate</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>NDRate</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT
size=2>Ordr</FONT></TH></TR></THEAD>
<TBODY>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD borderColor=#c0c0c0><FONT size=2>Single</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$45.75</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$50.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD borderColor=#c0c0c0><FONT size=2>Double</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$29.75</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$35.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>3</FONT></TD>
<TD borderColor=#c0c0c0><FONT size=2>Triple</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$21.34</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$25.33</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>3</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>4</FONT></TD>
<TD borderColor=#c0c0c0><FONT size=2>Quadruple</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$17.50</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$20.50</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>4</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>5</FONT></TD>
<TD borderColor=#c0c0c0><FONT size=2>Cabin</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$18.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$21.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>5</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>7</FONT></TD>
<TD borderColor=#c0c0c0><FONT size=2>Cabin/Staff</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$20.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$26.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>7</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9</FONT></TD>
<TD borderColor=#c0c0c0><FONT size=2>R/V</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$20.50</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$20.50</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>8</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>10</FONT></TD>
<TD borderColor=#c0c0c0><FONT size=2>Tent</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$10.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$10.25</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>9</FONT></TD></TR></TBODY>
<TFOOT></TFOOT></TABLE></SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=984463817-06052003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN
class=984463817-06052003>tlnklodgingEvent</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=984463817-06052003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=984463817-06052003>
<TABLE bgColor=#ffffff border=1 cellSpacing=0><FONT size=2>
<CAPTION>EventID FK to tblEvent Facility PK</CAPTION></FONT>
<THEAD>
<TR>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>EventID</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>Facility</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>LodgingID</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>NoUnits</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>Guests</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>NoNights</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>CostPerUnit</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT size=2>total</FONT></TH>
<TH bgColor=#c0c0c0 borderColor=#000000><FONT
size=2>LodgingDate</FONT></TH></TR></THEAD>
<TBODY>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9456</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>88</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$45.75</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$45.75</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>3/31/2003</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9457</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>89</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>5</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>5</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$45.75</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$228.75</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>4/ 1/2003</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9457</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>90</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>12</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>24</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$29.75</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$714.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>4/ 1/2003</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9458</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>94</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$29.75</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$59.50</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>3/31/2003</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9461</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>95</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>8</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>8</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$50.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$400.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>12/ 9/2002</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9461</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>96</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>9</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>9</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$50.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$450.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>12/10/2002</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9461</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>97</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>6</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>6</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$50.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$300.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>12/11/2002</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9461</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>98</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>11</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>22</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$35.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$770.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>12/ 9/2002</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9461</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>99</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>11</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>22</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$35.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$770.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>12/10/2002</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9461</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>100</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>15</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>30</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$35.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$1,050.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>12/11/2002</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9461</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>101</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$35.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$70.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>12/12/2002</FONT></TD></TR>
<TR vAlign=top>
<TD align=right borderColor=#c0c0c0><FONT size=2>9462</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>102</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>1</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>13</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>13</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>2</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$50.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT size=2>$1,300.00</FONT></TD>
<TD align=right borderColor=#c0c0c0><FONT
size=2>2/11/2003</FONT></TD></TR></TBODY>
<TFOOT></TFOOT></TABLE></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><SPAN class=984463817-06052003>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<BR><FONT
color=#0000ff><SPAN class=578524918-06052003>[Klos,
Susan] </SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=984463817-06052003><FONT color=#0000ff><SPAN
class=578524918-06052003>Example and rest of message follows. Please stay
with me. Thanks. </SPAN></FONT></SPAN></FONT></DIV></BODY></HTML>