Pass recordset to a query

[aprentice]

Is it possible to "convert" a recordset to a query sth?

What I want is to open a report with some data which come from a rst.
But passing rst as an input argument for a report is impossible (?). So I'm trying to convert it to a query.

Any suggestions?

Thnx

 

[boblarson]

Plus, just for semantics sake, a recordset essentially IS the results of a query, but some recordsets are created by the Jet engine behind the scenes while others are created by running a specific query that the user creates or uses.

 

[aprentice]

Ok let me elaborate..

I design a DB for a school. I store the infos of the Schedule to a join table and more specifically each record keeps Day/Time/ClassID(from tblClass)/ProfessorID(same)/LessonID(same).

At the report I don't want to present Schedule like
Monday
11:00 Less1 Prof4 Class3
12:00 .. .. ...
....

Tues
11:00
12:00
etc.

But Monday Tuesday Thursday
11:00 L/P/C L/P/C L/P/C
12:00 L/P/C L/P/C L/P/C
13:00 ... ... ...
............

where L/P/C are the relative Lesson/Professon/Class ID

The only way I believe I can achieve this is with the help of rst's and lots of code lines...

Any other suggestions?

 

[Rich]

Try a crosstab query

 

[aprentice]

I've tried but it's not properly for my case cos
as u can imagine in every hour of day several classes might are at the same time.

So I need sth like

Monday...Tuesday...Thursday
11:00 L/P/C......L/P/C...... L/P/C
12:00 L1/P1/C1...L/P/C.....L/P/C
12:00 L3/P3/C3
13:00
13:00
13:00
14:00

etc