Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Grouping by first word of field
Thanks for your quick response! I'm new to this, and I've been working on it for a while with little success. I'll tell you what I'm doing, and maybe you can find my error(s): I'm running the report from a query, qryComparison. The fields are [PlantName] [ShipDate] [NumberTrays] and...- lruthig
- Post #3
- Forum: Microsoft: Access Reports
-
Grouping by first word of field
I'd like to group my report not by the entire value of a field, or by the first letter or letters, but by the first word. The field has plant names, in the format: Pansy "Ultima Morpho" Petunia "Purple Wave" etc. I need to group all the pansies together, all the petunias...- lruthig
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
