Format report data in repeating columns & rows ?

[Ranvier]

How do I Format report data in repeating columns & rows

I have a report that I need to design which displays a staff roster. This is how I need the report to look like:

LON = List Of Names
Colums = Section number (1-7)
Row = Period number (1-5)

Date
Section
___________1 2 3 4 5 6 7
Period 1 LON LON LON LON LON LON LON
Period 2 LON LON LON LON LON LON LON
Period 3 LON LON LON LON LON LON LON
Period 4 LON LON LON LON LON LON LON
Period 5 LON LON LON LON LON LON LON

My query selects:
1/ A single date (based on a form field)
2/ All the staff that have been allocated to each period of the day and a section where they have been allocated to work. (35 instances each containing a list of names).
I cant do a crosstab because my list of names are text and not numerical.

i.e. My query result is similar to
Date Period Section Name

21 June 1 1 Name a
21 June 1 1 Name b
21 June 1 2 Name a
21 June 1 2 Name a
21 June 2 1 Name a
21 June 2 1 Name b
21 June 2 2 Name x
21 June 2 3 Name y
21 June 2 1 Name z
etc......................

My question is how do I get my ‘sections’ to appear in columns that correspond to my ‘periods’ instead of appearing in rows like a normal report.

Thanks in advance for any help.

 

[dhookom]

You might want to check out the crosstab report samples at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Ranvier]

Thanks I have had a look at the link but it has confused me a bit more and I don’t think the examples really do what I need.

I will try and simplify my example of the report I need to create and hopefully you might be able to advise me further.

For this example I will assume I need two columns, which will represent two different age group sections.
My rows will have five periods (periods in the day).
For each of the 5 periods there are 2 sections (columns) and in each section there will be a list of staff names that can contain 1 to n names. The trouble I am having is getting the sections columns side by side instead of continuing underneath each other one after another.
An important part of the report is the body, which will have a list of names under each section heading for each period.

EXAMPLE:

Age Section 1 Age Section 2
Period
1 John Fred
Mary Frank
Bert Tim
2 John Fred
William Frank
Bert Tim
3 John Fred
Mary Frank
Bert Tim
4 John Fred
Rose Mary
Tomy Tim
5 John Fred
Mary Frank
Bert Tim

How do I get the next column (in this case the 2nd column) to appear to the right of the previous column (in this case the 1st column) as per my example.

Thanks Again!

 

[dhookom]

You can get a "list" of names using the generic concatenate function found at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Use the Concatenate and "First" as the Value in the crosstab.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.