<!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 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=365172519-07052003>Okay
Susan....the following SQL:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=365172519-07052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=365172519-07052003>SELECT
tlnklodgingEvent.EventID, tblLodging.Type, tlnklodgingEvent.Guests,
tlnklodgingEvent.NoNights, tlnklodgingEvent.CostPerUnit, tlnklodgingEvent.total,
Format([LodgingDate],"ddd") AS Expr1<BR>FROM tblLodging RIGHT JOIN
tlnklodgingEvent ON tblLodging.LodgingID = tlnklodgingEvent.LodgingID<BR>WHERE
(((tlnklodgingEvent.EventID)=9461));</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=365172519-07052003>UNION
SELECT 9461 AS EventID, tblLodging.Type, 0 AS Guests, 0 AS NoNights,
tblLodging.DRate, tblLodging.NDRate, "(Depending on if is Diocesan Event or
NonDiocesan Event)" AS Day<BR>FROM tblLodging<BR>WHERE (((tblLodging.LodgingID)
Not In (SELECT tlnklodgingEvent.LodgingID FROM tlnklodgingEvent WHERE
(((tlnklodgingEvent.EventID)=9461)) GROUP BY
tlnklodgingEvent.LodgingID;)))<BR>ORDER BY NoNights DESC, Type
DESC;</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=365172519-07052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=365172519-07052003>Produces these results: (Note, the Cost per
unit and total are showing actual data from the tlnklodgingEvent table...I don't
know where you got the numbers from, for your sample
results....)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=365172519-07052003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=365172519-07052003></SPAN></FONT><FONT face=Arial color=#0000ff
size=2><SPAN class=365172519-07052003></SPAN></FONT> </DIV><FONT face=Arial
color=#0000ff size=2><SPAN class=365172519-07052003>
<DIV>
<TABLE borderColor=#000000 cellSpacing=0 cellPadding=2 width=681 border=1>
<TBODY>
<TR>
<TD width="14%" bgColor=#c0c0c0 height=18><B><FONT face=Arial size=2>
<P align=center>EventID</B></FONT></P></TD>
<TD width="14%" bgColor=#c0c0c0 height=18><B><FONT face=Arial size=2>
<P align=center>Type</B></FONT></P></TD>
<TD width="14%" bgColor=#c0c0c0 height=18><B><FONT face=Arial size=2>
<P align=center>Guests</B></FONT></P></TD>
<TD width="14%" bgColor=#c0c0c0 height=18><B><FONT face=Arial size=2>
<P align=center>NoNights</B></FONT></P></TD>
<TD width="14%" bgColor=#c0c0c0 height=18><B><FONT face=Arial size=2>
<P align=center>CostPerUnit</B></FONT></P></TD>
<TD width="14%" bgColor=#c0c0c0 height=18><B><FONT face=Arial size=2>
<P align=center>total</B></FONT></P></TD>
<TD width="14%" bgColor=#c0c0c0 height=18><B><FONT face=Arial size=2>
<P align=center>Expr1</B></FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Single</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>6</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>1</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$50.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$300.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Wed</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Single</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>8</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>1</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$50.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$400.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Mon</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Single</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>1</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$50.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$450.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Tue</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Double</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>2</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>1</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$35.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$70.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Thu</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Double</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>22</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>1</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$35.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$770.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Mon</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Double</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>22</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>1</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$35.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$770.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Tue</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Double</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>30</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>1</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$35.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$1,050.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Wed</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Triple</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$21.34</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$25.33</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>(Depending on if is Diocesan Event or NonDiocesan
Event)</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Tent</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$10.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$10.25</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>(Depending on if is Diocesan Event or NonDiocesan
Event)</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>R/V</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$20.50</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$20.50</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>(Depending on if is Diocesan Event or NonDiocesan
Event)</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Quadruple</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$17.50</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$20.50</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>(Depending on if is Diocesan Event or NonDiocesan
Event)</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Cabin/Staff</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$20.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$26.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>(Depending on if is Diocesan Event or NonDiocesan
Event)</FONT></P></TD></TR>
<TR>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>9461</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>Cabin</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>0</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$18.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=right>$21.00</FONT></P></TD>
<TD width="14%" bgColor=#ffffff height=18><FONT face=Arial size=2>
<P align=left>(Depending on if is Diocesan Event or NonDiocesan
Event)</FONT></P></TD></TR></TBODY></TABLE></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV></SPAN></FONT><FONT face=Tahoma><FONT size=2><SPAN
class=365172519-07052003><FONT face=Arial
color=#0000ff>Drew </FONT></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT size=2><SPAN
class=365172519-07052003> </SPAN>-----Original
Message-----<BR><B>From:</B> Klos, Susan
[mailto:Susan.Klos@fldoe.org]<BR><B>Sent:</B> Tuesday, May 06, 2003 1:51
PM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD]
FW: Query help please<BR><BR></DIV></FONT></FONT>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT size=2><FONT
color=#0000ff><SPAN class=609155118-06052003>Here is the second part of the
message</SPAN><BR><BR></FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff
size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>