Help with multiple reports please

  • Thread starter Thread starter Raje
  • Start date Start date
R

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

Raje said:
Hi,
Click to expand...
I am new to Access though I have some programming knowledge of Excel
and Word.
Click to expand...
I have a table/query with the following columns:
Project
Risk Category
Risk
Click to expand...
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).
Click to expand...
I need to make one report for each Project showing all the Risk
Categories and Risks.
Click to expand...
How do I do this either through the Access User Interface or VBA/
Macros in Access?
Click to expand...
Pointers to resources/tutorials with similar functionality also
welcome.
Click to expand...
Thanks in advance for all the Help.
Click to expand...
Regards.
Raj
Click to expand...
Click to expand...
 
Back
Top