Hi,
Access 2010.
My title is somewhat simplified on my request.
I have a number of fields, however whilst needing to show all fields per record, three fields are the fields of interest.
first has a unit number 1 2 3 through to 9,
the second has a group number I or II or III, 1 2 and 3 is in group I, 4 5 and 6 is in group II, 7 8 9 in group lll.
the third has the larger group name (lets call this field 'LGN' ) and it holds A B C D E etc these exist in. Each letter will have groups I II and II in it, thus each letter holds 9 units nos 1 to 9
A record could be 5 A which by being known also means its group II, or it might be II A if the unit is unknown but the group is known. I would fill in unit and group if the unit was known.
so records can be:-
1 A
II A
1 G
3 H
III D
5 B
7 A
7 D
2 A
3 J
7 H
I need to put the records into the order, whereby I deal with LGN A followed by B then C, and units in number order, with Group I showing after 1 2 and 3 have shown, II showing after 4 5 and 6 have shown and so on , so it would be looking like the order :-
1 A
2 A
II A
7 A
5 B
7 D
III D
1 G
3 H
7 H
3 J
how would I design the query which would make a new form show these in this order ?
Cheers
DBenz