Sorting/Grouping

[Kerry]

Hi

I have a list in my table which, when displayed in a
report I would like them in a specific order. The sort
field displays two digits of data, the first character is
a letter representing the month:-
Jan = F
Feb = G
March = H
Ar = J
May = K
June = M etc.....

The second character is a number representing the year
4,5,6 etc.

Entries made this month would be J5, next month K5. In
my database I have data from last year, and I will be
using this system for another couple of years.

When I generate a report I would like to display them in
the order of the year.

e.g. F4, G4, H4, J4, K4, ......Z4, F5, G5, H5, J5....Z5

when I create my report it orders them by all the F's
then all the G's etc. how can I get round this.

Many thanks

Kerry

 

[Duane Hookom]

You can set your sorting field/expression to something like:
=Right([YourField],1) & [YourField]

 

[Kerry]

Hi Duane

Many thanks for your suggestion. Where do I set the
expression? I need a report grouped by customer number
then by product, within that the order of my month & year
data (delivery).

I have created a report grouping by Customer No. then by
product then by delivery but I need the grouping of
delivery to be by your expression can I do that? It only
allows me Normal, 1st character, 2nd char etc, in the
wizard and I can't see how to change it in the properties.

Many thanks

Kerry

-----Original Message-----
You can set your sorting field/expression to something like:
=Right([YourField],1) & [YourField]


--
Duane Hookom
MS Access MVP

Hi

I have a list in my table which, when displayed in a
report I would like them in a specific order. The sort
field displays two digits of data, the first character is
a letter representing the month:-
Jan = F
Feb = G
March = H
Ar = J
May = K
June = M etc.....

The second character is a number representing the year
4,5,6 etc.

Entries made this month would be J5, next month K5. In
my database I have data from last year, and I will be
using this system for another couple of years.

When I generate a report I would like to display them in
the order of the year.

e.g. F4, G4, H4, J4, K4, ......Z4, F5, G5, H5, J5....Z5

when I create my report it orders them by all the F's
then all the G's etc. how can I get round this.

Many thanks

Kerry

.

 

[Duane Hookom]

Don't use the wizard. Open your report in design view and then view the
Sorting and Grouping dialog and enter the expression I suggested.

--
Duane Hookom
MS Access MVP

Hi Duane

Many thanks for your suggestion. Where do I set the
expression? I need a report grouped by customer number
then by product, within that the order of my month & year
data (delivery).

I have created a report grouping by Customer No. then by
product then by delivery but I need the grouping of
delivery to be by your expression can I do that? It only
allows me Normal, 1st character, 2nd char etc, in the
wizard and I can't see how to change it in the properties.

Many thanks

Kerry

-----Original Message-----
You can set your sorting field/expression to something like:
=Right([YourField],1) & [YourField]


--
Duane Hookom
MS Access MVP

Hi

I have a list in my table which, when displayed in a
report I would like them in a specific order. The sort
field displays two digits of data, the first character is
a letter representing the month:-
Jan = F
Feb = G
March = H
Ar = J
May = K
June = M etc.....

The second character is a number representing the year
4,5,6 etc.

Entries made this month would be J5, next month K5. In
my database I have data from last year, and I will be
using this system for another couple of years.

When I generate a report I would like to display them in
the order of the year.

e.g. F4, G4, H4, J4, K4, ......Z4, F5, G5, H5, J5....Z5

when I create my report it orders them by all the F's
then all the G's etc. how can I get round this.

Many thanks

Kerry

.