Access Reporting - Groups and Sub-Groups - NEED HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Aftrenoon all, I have a qucik questions that I hope that someone can
help me with. I have a report in Access that has the record sources back to
a query. What I want to do is the following, I want to have a section header
then some detailed data, then another section header, them some more dteailed
data, etc etc. For example:

Matched Items (section header)
1. (detailed data)
2. (detailed data)
3. (detailed data)

Missed Items (section header)
1. (detailed data)
2. (detailed data)
3. (detailed data)

Additional Items (section header)
1. (detailed data)
2. (detailed data)
3. (detailed data)

Any help would be greatly appreciative...
 
All you should have to do is create a group header on your field containing
"Matched Items","Missed Items", and "Additional Items".

If you can't figure this out, come back with field/column information and
sample records.
 
Thanks for the information. The background behind this database is the
following: We have assets in a certain department that we are tracking with
this database. At any point in time an audit can be performed on that
specific location (office) for those assets. A form was created to enter in
all the assets that are within that location and once the user selects the
audit button a report displays with the following information.

Matched Items within the audit - assets that the auditor inserted matching
with the assets that were stored in the database.

Missing Assets within the audit - assets that the database had stored but
the auditor did not insert when the audit was performed.

Additional Assets within the audit - assets that the auditer inserted that
does not match with any of the assets within the database.

The first part of my problem is that I have 3 queries, Matched Assets Query,
Missing Assets Query, and Additional Assets Query. I am having a difficult
time with the Additional Assets Query since the values are inserted by a user
and not taken from a table plus the logic.

The second part of the problem is the reporting, I was looking to have 3
sections, Matched Assets, Missing Assets, and Additional Assets. But I
cannot group all of the data under one section.
 
We still don't know much about your actual data. You stated there are
Matched Items but we don't know what value in what field states they are
matched. Without that knowledge it is near impossible to more than guess at
your structures and data.

If you have three queries, you can use a subreport for each query and place
them on a main report.
 
Back
Top