How to group data based on a portion of an account code

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

Guest

I have an account code field that has numbers in the following format:

01-02-60-00
01-02-61-00
01-03-60-00
01-04-61-00
01-11-63-00

I have a large data set for this report. How can I group the data in the
report based on the fourth and fifth charactors (i.e., 02, 03, 04, 11)?

Thanks
 
You can use expressions in your sorting and grouping field/expression
column. Try
=Mid([AccountCode],4,2)
 
Thanks Duane it did exactly what I needed!!

Bob

Duane Hookom said:
You can use expressions in your sorting and grouping field/expression
column. Try
=Mid([AccountCode],4,2)

--
Duane Hookom
MS Access MVP


Bob said:
I have an account code field that has numbers in the following format:

01-02-60-00
01-02-61-00
01-03-60-00
01-04-61-00
01-11-63-00

I have a large data set for this report. How can I group the data in the
report based on the fourth and fifth charactors (i.e., 02, 03, 04, 11)?

Thanks
Click to expand...
Click to expand...
 
Back
Top