Display all prossible sets

  • Thread starter Thread starter Karren Lorr
  • Start date Start date
K

Karren Lorr

Hello

I am just starting to create this so I can re-do the whole thing if I need.

Say I have a table with class rooms in
TableClassRooms
RoomID
RoomNumber
RoomFacilities
etc

And another table with possible dates

TableDates
DateID
DateStart
DateEnd
etc

How can I join these tables so I can see all possible mixes.

eg.

01/01/2009 Room1 Room2 Room3 etc
02/01/2009 Room1 Room2 Room3 etc
03/01/2009 Room1 Room2 Room3 etc

Thank you if you can offer any help with this
 
hi Karren,

Karren said:
I am just starting to create this so I can re-do the whole thing if I need.
And another table with possible dates
How can I join these tables so I can see all possible mixes.
Click to expand...
You need a cross join. Create a new query and open it in design view.
Add both tables to it and remove the reference line between them, if
there is any added by Access. Choose your fields and you're done.


mfG
--> stefan <--
 
Back
Top