Search results

Thanks CJ_London, I would try the last part, create a report for each then use both as subreports on a third report.

Hi guys thanks for your help! Attached is a sample of what I am trying to do. For the report instead of showing guest info + room info for Mike, guest info + room info for Flore, and guest info + room info for Desire I would like it to show first all guest info of Mike, Flore, Desire and then...

I have a report with many textboxes in the detail section that read from a single query. One row of the query contain the info needed for all 10 textboxes, lets say each textbox show the data of each column of the query. the top 5 textboxes are related to guest info and the bottom 5 textboxes...