Report Grouping, Access 2000 & 2003

[jfcby]

Hello,

My query is setup and sorted like this and I need my report grouped
together like but not sorted:

Field1 Field2 Field3

I need the AHU grouped together.
AHU-A TASK1 DESCRIPTION1
AHU-A TASK2 DESCRIPTION2
AHU-S TASK3 DESCRIPTION3
AHU-S TASK4 DESCRIPTION4
AHU-Q TASK5 DESCRIPTION5
AHU-Q TASK6 DESCRIPTION6

I need the FCU/UV grouped together.
FCU/UV-A TASK7 DESCRIPTION7
FCU/UV-A TASK8 DESCRIPTION8
FCU/UV-S TASK9 DESCRIPTION9
FCU/UV-S TASK10 DESCRIPTION10
FCU/UV-Q TASK11 DESCRIPTION11
FCU/UV-Q TASK12 DESCRIPTION12
FCU/UV-Q TASK13 DESCRIPTION13

I need the TTWHVAC grouped together.
TTWHVAC-A TASK14 DESCRIPTION14
TTWHVAC-A TASK15 DESCRIPTION15
TTWHVAC-S TASK16 DESCRIPTION16
TTWHVAC-S TASK17 DESCRIPTION17
TTWHVAC-Q TASK18 DESCRIPTION18
TTWHVAC-Q TASK19 DESCRIPTION19

When I create my report it only groups the AHU-A, AHU-S, AHU-Q but I
need it grouped as described above. The grouping feature will not do
that since Field1 has multiply charcters to use when grouping.

The grouping feature has only ascending and descending sort options I
need no sort.

How can I create my Report so that it is grouped as described above
with no sort?

Thank you for your help,
jfcby

 

[Van T. Dinh]

Create a Calculated Field in your Query:

MyGroupSortField: Left([Field1], 3)

and in your Report, set Grouping & Sorting by this Calculated Field.

 

[jfcby]

Hello Van,

Create a Calculated Field in your Query:

MyGroupSortField: Left([Field1], 3)

and in your Report, set Grouping & Sorting by this Calculated Field.

I already have my query sorted like this SQL:

SELECT dbTEST.[Part Number], dbTEST.[Price $], dbTEST.[Part
Description], Left([Part Description],2), IIf(Right([Part
Description],1)='S','B',Right([Part Description],1))
FROM dbTEST
WHERE (((dbTEST.[Part Description]) Like "*[*]?*"))
ORDER BY Left([Part Description],2), IIf(Right([Part
Description],1)='S','B',Right([Part Description],1));

I have my query sorted on the first letter is ascending and the last
letter is sorted A, S, Q. Is there a way to group with no sort? Is
there another method to use in creating my report than grouping?

Thank you for your help,
jfcby