Display all prossible sets

[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

 

[Stefan Hoffmann]

hi Karren,

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.

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 <--

 

[Karren Lorr]

That works perfectly

Thank you so much for your help