Group a report based on part of field?

[misscrf]

I have inventory data for a school's computers. I will need to break down the data eventually, but here is the grit of it. I have a pk auto number, the room number that the computer is in, an assigned number to the computer in that room ( 1-10, ie 10 computers in that room) and each monitor and workstation serial etc.
On this report I need multiple grouping. At the start I would like to have the sum of all computers in the school. Then I need to break it down by what floor the computers are on. So here comes the question. How do I create a group for the first floor, so I can sum at that level, and for the second floor and so on? the room field had to be text because there are some rooms that are 204A and 303B. for arguments sake, and accounting the text, how do I make a field for 1*** = 1 and 2***=2 etc? Does that sound clear? I appreciate any help I can get!!!!
Thanks all!

 

[SuicidED]

In sorting and grouping on your report put an expression =Left([Your field name],1) and add headers/footers to suit.

 

[dhookom]

The sorting and grouping also allows you to select
Group On: Prefix Characters
Group Interval: 1

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[misscrf]

Thanks to both of you. It's all coming back to me now! Your help has saved me a lot of frustration and agony.

And now I have another question for this report. If I should ask this in a different thread, let me know and I will do so. I want to have the total number of computers listed at the top of the report, but I can only seem to get this count when I put the formula in the report header. That would be fine, but then it appears above the page header which looks odd. How do I display the total count of computers under the page header as a predecessor to the next level being each floor of the school?

The final layout should be total for school, total for floor, and list by class room. I have all of this except for the formatting of the total for school. If you can help I would be quite grateful!
Thanks all...

 

[dhookom]

Can you create a School header and put the total in it?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[misscrf]

I was able to just use a different field ( inventory) and group on the 99999 interval