Grouping in Reports

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

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!
 
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 ;)
 
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, ...
Click to expand...

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
__________________________________________

Jennifer Cali said:
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!
Click to expand...
 
Back
Top