Re: Three table query

From: dave (dave_at_dave.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 21:25:51 +0100

Okay groupA are Staff and GroupB are Students therefore I don't really
want to put them in one table.

Each person in either groupA or GroupB has a field titled RoomID. In the
Rooms table I have the primary key as a field RoomID along with another
field with the room name itself.

I need a report to show me who is in each room both staff and students

"Rick B" <Anonymous> wrote in message
news:eMtNsYxqEHA.1272@TK2MSFTNGP09.phx.gbl...
> Do you have a like field between the tables? Are does your "Rooms" table
> have a name field? Does your GroupA table have a "rooms" field?
>
> How does the database know who is in which room?
>
> Why so you have two Group tables? Why not just a "Person" table with a
> name
> field, and a group field? You really want to create new tables as you add
> groups?
>
> Sounds like you have not followed proper database structure.
>
>
> Rick B
>
>
> "dave" <dave@dave.com> wrote in message
> news:4162f994$0$44850$ed2619ec@ptn-nntp-reader02.plus.net...
>> Hi
>>
>> I have three tables: GroupA, GroupB and Rooms. GroupA and GroupB
>> contain people. Rooms contains a list of rooms.
>>
>> I want to produce a query that will show me a list of rooms with all the
>> people from GroupA and groupB in it. Something like
>>
>> Room People
>>
>> First Room GroupA Fred (from GroupA)
>> Joe (from GroupA)
>> GroupB Stan (from GroupB)
>>
>> Second Room GroupA Bill (from GroupA)
>> GroupB Jim (From GroupB)
>>
>>
>> Any ideas?
>>
>> Thanks
>>
>>
>
>

Relevant Pages

  • Re: Three table query
    ... It would be easiest if you put students and staff in the same table. ... > Each person in either groupA or GroupB has a field titled RoomID. ...
    (microsoft.public.access.queries)
  • Re: Is every user a member of Users?
    ... >>E.g., if GroupA includes GroupB, then the members of GroupB are ... >>effectively members of GroupA. ... resources/permissions and/or set of rights for doing ...
    (microsoft.public.win2000.security)
  • Re: Problem with empty pages
    ... outermost group, then GroupB - which can contain multiple pages of data, ... GroupB will be multiple pages I get a page with just the Group header on a ... That is followed by a page with the new GroupA, ... In the change group, option, on the second tab, is keep group together ...
    (microsoft.public.vb.crystal)
  • Re: Problem with empty pages
    ... GroupB will be multiple pages I get a page with just the Group header on a ... That is followed by a page with the new GroupA, GroupB and GroupC ...
    (microsoft.public.vb.crystal)
  • Re: Address list and over 10.000 contacts
    ... Than make GroupA a member of GroupB ... Alexander Zammit ... ExchangeInbox.com the new MS Exchange Resource site at ...
    (microsoft.public.exchange.admin)