Hi. I have a report with a subreport that shows today's check ins. The subreport is really simple, showing just property, guest name and phone number. The source data is a query.
I need more info in this report, such as today's checkouts. Can I just use the same subreport with different query for source, and position it next to the check ins to display this data or do I need to create a different subreport?
mafhobb
Code:
SELECT tblReservations.[ID], tblReservations.[PropertyName], tblReservations.[GuestName], tblReservations.[CheckInDate], tblReservations.CheckOutDate, tblReservations.[CleaningComments], tblReservations.[Status], tblReservations.[PhoneNumber] FROM tblReservations WHERE (((tblReservations.CheckInDate)=Date()) And ((tblReservations.Status)="Active"));
Code:
tblReservations.[ID], tblReservations.[PropertyName], tblReservations.[GuestName], tblReservations.[CheckInDate], tblReservations.CheckOutDate, tblReservations.[CleaningComments], tblReservations.[Status], tblReservations.[PhoneNumber] FROM tblReservations WHERE (((tblReservations.CheckOutDate)=Date()) And ((tblReservations.Status)="Active"));