Grouping in Reports

[Guest]

I'm trying to create a report that prints customers grouped by first letter
of their name. I was using the left function to return first character of
product names, but instead of getting the desired "grouping" effect (the
letter "A" followed by each customer who had a name beginning with the letter
"A") each was showing up ungrouped (the letter would appear above each
customer, with the letter appearing multiple times).

WHAT I USED: =Left([chrCustName],1)
WHERE I PUT IT: In the chrCustName Header. All other fields were in the
details section.

Any help you can offer would be greatly appreciated!

 

[strive4peace]

Hi Jennifer,

in the sorting and grouoing window (from the menu --> View,
Sorting & Grouping), make 2 lines

1. group by first letter

Field/Expression --> chrCustName
GroupHeader --> Yes
GroupOn --> Interval
GroupInterval --> 1

2. sort by name
Field/Expression --> chrCustName

then, you can use a calculated control in the group header
ControlSource --> =Left([chrCustName],1)

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

 

[Guest]

Hi Jennifer,

Have you looked at the sample report in Northwind named "Alphabetical List
of Products"? It sounds like you want to do something similar, except use a
customer list instead of a list of products. However, I must admit that I'm a
little confused about your reference to product names:

I was using the left function to return first character of
product names, ...

since your report appears to deal with customers, not products.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

I'm trying to create a report that prints customers grouped by first letter
of their name. I was using the left function to return first character of
product names, but instead of getting the desired "grouping" effect (the
letter "A" followed by each customer who had a name beginning with the letter
"A") each was showing up ungrouped (the letter would appear above each
customer, with the letter appearing multiple times).

WHAT I USED: =Left([chrCustName],1)
WHERE I PUT IT: In the chrCustName Header. All other fields were in the
details section.

Any help you can offer would be greatly appreciated!