Help with multiple reports please

[Raje]

Hi,

I am new to Access though I have some programming knowledge of Excel
and Word.

I have a table/query with the following columns:
Project
Risk Category
Risk

For every Risk in the third column, the second column has the
associated Risk Category (there are 5 categories) and the first column
has the associated Project (name).

I need to make one report for each Project showing all the Risk
Categories and Risks.

How do I do this either through the Access User Interface or VBA/
Macros in Access?

Pointers to resources/tutorials with similar functionality also
welcome.

Thanks in advance for all the Help.

Regards.
Raj

 

[KARL DEWEY]

Try this and see if it is what you want as output --
SELECT Raje.Project, Raje_1.[Risk Category], Raje_2.Risk
FROM Raje, Raje AS Raje_1, Raje AS Raje_2;

If not then you need to explain a little more.

 

[Raje]

Thanks for the response. I do need to clarify.

The report has already been designed is named projectrisks. When
"projectrisks" is opened it asks for the project id (this field is
also there in the underlying query). On inputting the id, a report is
generated for that project. I need an automated way (macros/vba/user
interface) of looping through the project id (either distinct values
in the underlying query or from another table with unique project ids)
to generate as many reports as the project ids.

Thanks in Advance
Raje

Try this and see if it is what you want as output --
SELECT Raje.Project, Raje_1.[Risk Category], Raje_2.Risk
FROM Raje, Raje AS Raje_1, Raje AS Raje_2;

If not then you need to explain a little more.

Hi,

I am new to Access though I have some programming knowledge of Excel
and Word.

I have a table/query with the following columns:
Project
Risk Category
Risk

For every Risk in the third column, the second column has the
associated Risk Category (there are 5 categories) and the first column
has the associated Project (name).

I need to make one report for each Project showing all the Risk
Categories and Risks.

How do I do this either through the Access User Interface or VBA/
Macros in Access?

Pointers to resources/tutorials with similar functionality also
welcome.

Thanks in advance for all the Help.

Regards.
Raj