Re: Three table query

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 10/06/04 

Date: Tue, 5 Oct 2004 20:04:45 -0500

It would be easiest if you put students and staff in the same table. It's
not like they will mingle and get in trouble. An alternative is to use a
union query that pseudo appends students to staff or staff to students. 

-- 
Duane Hookom
MS Access MVP
"dave" <dave@dave.com> wrote in message
news:416300b1$0$44854$ed2619ec@ptn-nntp-reader02.plus.net...
> 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
    ... Okay groupA are Staff and GroupB are Students therefore I don't really ... Each person in either groupA or GroupB has a field titled RoomID. ...
    (microsoft.public.access.queries)
  • Re: Mad bad magic at EMU
    ... Victim's parents and students question Eastern Michigan University's ... By P.J. Huffstutter, Times Staff Writer ... the school said. ...
    (rec.sport.football.college)
  • One of the story of Communist Army leader Ne Win
    ... On March 2 1962, the Chief of Staff of the Armed Forces of Burma, ... Maung, a Sino-Burmese, as the Chief of Staff formed the Revolutionary ... Council with his Vice Chief of Staff for Army Brigadier Aung Gyi, ... one of the points was that all students must be in their respective ...
    (soc.culture.burma)
  • Re: Maybe eye-surgery soon
    ... greater difficulty in maintaining striking or impact-weapon range, ... of & no way to pass on my staff experience & insights. ... assuming that there would be more time & future students someday. ... it wouldn't be the loss of doing martial arts per se but only ...
    (rec.martial-arts)
  • Re: Using Shift-Startup
    ... While still in the same command prompt, ... It will be placed on a shared drive, where students have read-only access ... and staff have read and write access. ... Is there a way to stop students by-passing the initial startup, ...
    (microsoft.public.access.security)