If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Possible to make a report from several queries?
Hello,
I posted this also in Queries, but since this affects both Queries and Reports, I thought it best to post it here as well. I'm new to Access and unfortunately been tasked to take care of someone else's DB. The question I have is, I need to make a report that uses 12 fields of data. But the thing is, I need to have the report to categorise the 12 fields in into 12 categories. If I make 12 different queries to handle the categories, I don't know if I can combine them into 1 query. I don't know how to make just one query to be able to make the 12 different categories for a report. The 12 fields a Identifier, T Severity, V severity, Status, Date opened, Date Closed, Description, Findings, T info, C info, C Action, P Action, and Additional Comments. The Status determines the category and there are 12 different status. If I can do this with one query and have the report separate them in the 12 categories, it would be perfect. Also if its possible to have the report to be able to sort the Status field into the 12 categories would be useful as well. I'm not sure if this is possible but would like to know if it is or if I need to try something else. Thank you for any possible help you can give me. |
#2
|
|||
|
|||
Possible to make a report from several queries?
Other than your table structure seeming un-normalized, I'm not sure what you
are asking for. I don't know why you need to create multiple similar queries when you report can simply group on the status field. -- Duane Hookom Microsoft Access MVP "Hell-fire" wrote: Hello, I posted this also in Queries, but since this affects both Queries and Reports, I thought it best to post it here as well. I'm new to Access and unfortunately been tasked to take care of someone else's DB. The question I have is, I need to make a report that uses 12 fields of data. But the thing is, I need to have the report to categorise the 12 fields in into 12 categories. If I make 12 different queries to handle the categories, I don't know if I can combine them into 1 query. I don't know how to make just one query to be able to make the 12 different categories for a report. The 12 fields a Identifier, T Severity, V severity, Status, Date opened, Date Closed, Description, Findings, T info, C info, C Action, P Action, and Additional Comments. The Status determines the category and there are 12 different status. If I can do this with one query and have the report separate them in the 12 categories, it would be perfect. Also if its possible to have the report to be able to sort the Status field into the 12 categories would be useful as well. I'm not sure if this is possible but would like to know if it is or if I need to try something else. Thank you for any possible help you can give me. |
#3
|
|||
|
|||
Possible to make a report from several queries?
Hi Duane,
Thank you for responding to my post. I'm still new to Access, so not really which way to proceed. I know a little about the sorting and grouping window. Also with this report, its has two other types of information to be included. One is like a totals table, the the 12 categories, and lastly a detail. The person that assigned this project to me, prefers everything to be in one report instead of 3. Would it be better to use subreports for each when making this report? Thank you. "Duane Hookom" wrote: Other than your table structure seeming un-normalized, I'm not sure what you are asking for. I don't know why you need to create multiple similar queries when you report can simply group on the status field. -- Duane Hookom Microsoft Access MVP "Hell-fire" wrote: Hello, I posted this also in Queries, but since this affects both Queries and Reports, I thought it best to post it here as well. I'm new to Access and unfortunately been tasked to take care of someone else's DB. The question I have is, I need to make a report that uses 12 fields of data. But the thing is, I need to have the report to categorise the 12 fields in into 12 categories. If I make 12 different queries to handle the categories, I don't know if I can combine them into 1 query. I don't know how to make just one query to be able to make the 12 different categories for a report. The 12 fields a Identifier, T Severity, V severity, Status, Date opened, Date Closed, Description, Findings, T info, C info, C Action, P Action, and Additional Comments. The Status determines the category and there are 12 different status. If I can do this with one query and have the report separate them in the 12 categories, it would be perfect. Also if its possible to have the report to be able to sort the Status field into the 12 categories would be useful as well. I'm not sure if this is possible but would like to know if it is or if I need to try something else. Thank you for any possible help you can give me. |
Thread Tools | |
Display Modes | |
|
|