If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Logical Nots in Subreports
Can someone please tell me if this is possible in Access:
I am trying to generate a report that lists a person who has a reservation at a hotel that includes a subreport of all the roomates that person has. I have this query to find the roomates: Select Name from table_people as A, table_people as B Where A.roomID = B.roomID AND A.PID B.PID To be verbose, I am trying to grab all the people in the same room that do not have the ID number of the person I am currently processing. (Does that make scence?) I wrote this with the assumption that a linked report would iterate through the values from the main report and plug them into my equality tests. My question is two-fold. How do link Access reports process interacting queries (all at once? or step-by-step?) and How can I exclude records in the subreport based on values from the main report? Thank you for accepting this challenge |
#2
|
|||
|
|||
Logical Nots in Subreports
By linking the report and the subreport by roomID I can see all the
people who are in the same room, which is useful. But my questions still remain? How do I exclude the current record (in the main report) from the list of those who are in the room (in the subreport)? I think my tests conclude that subreports do generate based on each iterative step. Otherwise how can I get subreports with only information that relates to the current roomID? So I only have one unaswered question. Is anyone willing to take up the challenge? Chris |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
REPOST - Keep subreports on one page | Rick B | Setting Up & Running Reports | 1 | August 2nd, 2004 06:29 PM |
Logical Function Override | Peo Sjoblom | Worksheet Functions | 2 | February 26th, 2004 02:16 PM |
Logical test to return one of three values | Peo Sjoblom | Worksheet Functions | 2 | November 7th, 2003 07:00 PM |
More Logical Test Needed. | Krappo | Worksheet Functions | 4 | October 8th, 2003 07:57 PM |