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

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
 
D

Duane Hookom

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

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report concantanates instead of adding values. 1
PR_RTF_COMPRESSED open failed 0
How to interpret CPUZ spd readouts? 5
How to enter start and end date/time in excel based on some specific value. 7
Show total (count) of text based entries 4
How to convert half hourly data into hourly 5
Windows - Application Error - The memory could not be read! 1
How to avoid Duplicate values .. but want the first value to added in group totals 0

Top