By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,224 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,224 IT Pros & Developers. It's quick & easy.

How to split report on Group data.....

P: n/a
Hi,

I have a report for which each record is a product.

I have the fields: ProductName and GroupCode

There may be several variants on each ProductName, BUT, with the same
group code

i.e.

Product A + Label, GROUP 1
Product A + Box, GROUP 1
Product A + Logo, GROUP 1

Product B + Label, GROUP 2
Product B + Box, GROUP 2
I want to print a report as follows:

List the records by ProductName as in 'A' above for example and then
place a line division after that group code, i.e. between Group 1
records & group 2 records.

I would also like to separate the groups via white and grey shading if
possible.

How do I do this

Thanks
David

Nov 14 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
David wrote:
Hi,

I have a report for which each record is a product.

I have the fields: ProductName and GroupCode

There may be several variants on each ProductName, BUT, with the same
group code

i.e.

Product A + Label, GROUP 1
Product A + Box, GROUP 1
Product A + Logo, GROUP 1

Product B + Label, GROUP 2
Product B + Box, GROUP 2
I want to print a report as follows:

List the records by ProductName as in 'A' above for example and then
place a line division after that group code, i.e. between Group 1
records & group 2 records.

I would also like to separate the groups via white and grey shading if
possible.

How do I do this

Thanks
David

Create a query. Drop the Group and ProductName. Right click in some
white space near a table and set the properties to UniqueValues = Yes.

Now create the report. Click on the Edit menu item and select Grouping
and Sorting.

As far as shading, there is some discussion on that in the Access
Developers Handbook. If you don't have it, check GoogleGroups.
Nov 14 '05 #2

P: n/a
Hi,

Re:
Create a query. Drop the Group and ProductName. Right click in some
white space near a table and set the properties to UniqueValues = Yes.

What does uniqueValue do ?

All I want to do is add a horizontal rule accross the report page when
the GROUP changes, so that all the same grouped products are together.
There must be some simple VBA to do this in one of the headers ?

Thanks again

David
*** Sent via Developersdex http://www.developersdex.com ***
Nov 15 '05 #3

P: n/a
David Gordon wrote:
Hi,

Re:
Create a query. Drop the Group and ProductName. Right click in some
white space near a table and set the properties to UniqueValues = Yes.

What does uniqueValue do ?
If you have 10 GroupA's, it only returns 1 record, not all 10. I
misunderstood your question.
All I want to do is add a horizontal rule accross the report page when
the GROUP changes, so that all the same grouped products are together.
There must be some simple VBA to do this in one of the headers ?
As I mentioned in my first post, go to Google Groups. I entered the
following
shading report lines group:*access*
into the search box.

Thanks again

David
*** Sent via Developersdex http://www.developersdex.com ***

Nov 15 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.