Need URGENT help creating a report 2

[Rmcta]

I am given data in Excel. I imported it into a table in Access.
I need to create a report which shows SECTION TITLE, SECTION SUBTITLE and then all the questions.
I can figure out how to do it with the way the data is given to me.

Here is what I have:

TBLMAIN
Section
SubSection
Item
Question
---------------------------------------------------
Section Subsection Item Question/Title
0 0 0 MAIN TITLE
1 0 0 SECTION TITLE
1 0 SUBSECTION TITLE
1 Question One
2 Question Two
2 0 SUBSECTION TITLE
1 Question One
2 Question Two
3 Question Three
4 Question Four
2 0 0 SECTION TITLE
1 0 SUBSECTION TITLE
1 Question One
2 Question Two

How do I do it?
PLEASE HELP!

 

[luceze]

Go to View/Sorting and Grouping. Add a group header for Section Title. Add a group header for Section Subtitle. Then place the Section Title in its header and the Subtitle in its header. Put the questions in the detail section. I believe the report wizard will give you these options if you use it.

HTH,
Eric

 

[Rmcta]

Eric,
I understand what you are saying however I can't get this right and I think it is because the titles for each section and subsection are in the same column as the questions itself.
How do I solve the problem?

 

[GingerR]

try to import the file in such a way as to parse out the title and subtitle from the question. are they separated by spaces?

 

[Rmcta]

I have just created:
tblTitle
tblSection
tblSubsection

I deleted from tblMain all records that included titles and only left the records that have questions.

What do I do now?

 

[Rmcta]

Actually..disregard tblTitle as that is the main title and I can just put a label on top of the report.
What I now have are 3 tables:
tblMain - which contains all the rows
tblSection - which contains section number and title
tblSubSection which contains section number, subsection number and title of the subsection.

I am not sure how to proceed now. I probably have to construct a query but how?

 

[Rmcta]

This is working:

SELECT tblMain.[Section Number], tblMain.[Audit Question], tblSection.SectionTitle
FROM tblSection INNER JOIN tblMain ON tblSection.[Section Number] = tblMain.[Section Number];

But now..how do I join tblSubSection where I have subsection titles?
I am not sure how to do it because the data I have there is:
Section 1 subsection 1
Section 1 subsection 2
Section 1 subsection 3
Section 2 subesction 1
Section 2 subsection 2 etc.

Can somebody please help?

 

[Rmcta]

Done. Sorry for the too many question. I was finally able to figure it out.
Thank you for your help!