grouping

[stephendeloach via AccessMonster.com]

In my report I have it sorted by Category.. My categories are 1 - BBH, 2 -
ABD... all the way to 15 - Repairs. When it is sorted its 1 - BBH 12 -
Housing 13 - Fuel... and so on. How can i make it 1, 2, 3, 4... ??

 

[Duane Hookom]

The report is sorting as designed. You might try change the sorting and
grouping expression to:
=Val([Category])

 

[stephendeloach via AccessMonster.com]

That still didnt work... Any other suggestions? Thanks

The report is sorting as designed. You might try change the sorting and
grouping expression to:
=Val([Category])

In my report I have it sorted by Category.. My categories are 1 - BBH, 2 -
ABD... all the way to 15 - Repairs. When it is sorted its 1 - BBH 12 -
Housing 13 - Fuel... and so on. How can i make it 1, 2, 3, 4... ??

 

[Duane Hookom]

"still didnt work" ...? Can you be a little more specific? What exactly did
you enter as the Sorting and Grouping expression and what were your results?

--
Duane Hookom
Microsoft Access MVP

That still didnt work... Any other suggestions? Thanks

The report is sorting as designed. You might try change the sorting and
grouping expression to:
=Val([Category])

In my report I have it sorted by Category.. My categories are 1 - BBH, 2 -
ABD... all the way to 15 - Repairs. When it is sorted its 1 - BBH 12 -
Housing 13 - Fuel... and so on. How can i make it 1, 2, 3, 4... ??

 

[stephendeloach via AccessMonster.com]

Sorry. I entered =Val([Category]) in the query under criteria and ran the
query and nothing came up. When it isnt entered all the categories come up...

"still didnt work" ...? Can you be a little more specific? What exactly did
you enter as the Sorting and Grouping expression and what were your results?

That still didnt work... Any other suggestions? Thanks

[quoted text clipped - 5 lines]

 

[Klatuu]

You misunderstood what Duane was saying.
You can do this one of two ways depending on what you are doing. You stated
you are sorting. Where in the report are you doing this sort? If it is
using the Sorting and Grouping, then rather than using the [Category] field
which is text, use Val([Category]) which will return only the numeric part of
[Category]. If you are not using sorting and grouping, create a calculated
field using the same formula and set it to sort ascending.
--
Dave Hargis, Microsoft Access MVP

Sorry. I entered =Val([Category]) in the query under criteria and ran the
query and nothing came up. When it isnt entered all the categories come up...

"still didnt work" ...? Can you be a little more specific? What exactly did
you enter as the Sorting and Grouping expression and what were your results?

That still didnt work... Any other suggestions? Thanks

[quoted text clipped - 5 lines]

ABD... all the way to 15 - Repairs. When it is sorted its 1 - BBH 12 -
Housing 13 - Fuel... and so on. How can i make it 1, 2, 3, 4... ??

 

[Duane Hookom]

As per Dave and my suggestion, use the sorting and grouping dialog in your
report design to reliably sort your report. When you enter the expression we
suggested, make sure you precede the expression with =.
--
Duane Hookom
Microsoft Access MVP

You misunderstood what Duane was saying.
You can do this one of two ways depending on what you are doing. You stated
you are sorting. Where in the report are you doing this sort? If it is
using the Sorting and Grouping, then rather than using the [Category] field
which is text, use Val([Category]) which will return only the numeric part of
[Category]. If you are not using sorting and grouping, create a calculated
field using the same formula and set it to sort ascending.
--
Dave Hargis, Microsoft Access MVP

Sorry. I entered =Val([Category]) in the query under criteria and ran the
query and nothing came up. When it isnt entered all the categories come up...

"still didnt work" ...? Can you be a little more specific? What exactly did
you enter as the Sorting and Grouping expression and what were your results?

That still didnt work... Any other suggestions? Thanks

[quoted text clipped - 5 lines]
ABD... all the way to 15 - Repairs. When it is sorted its 1 - BBH 12 -
Housing 13 - Fuel... and so on. How can i make it 1, 2, 3, 4... ??

 

[stephendeloach via AccessMonster.com]

Im confused. Let me explain a little more. When I made the report I added a
Grouping level, Category, not sorting. Sorry. Im new to this. Now where would
I put the =Val(Category) ?? Sorry

As per Dave and my suggestion, use the sorting and grouping dialog in your
report design to reliably sort your report. When you enter the expression we
suggested, make sure you precede the expression with =.

You misunderstood what Duane was saying.
You can do this one of two ways depending on what you are doing. You stated

[quoted text clipped - 15 lines]

 

[Duane Hookom]

Go to the design view of your report. View the Sorting and Grouping dialog
box. Replace the [Category] with:
=Val([Category])

"Grouping" and "sorting" are about the same concept. You can sort without
creating groups but you can't create groups without sorting.
--
Duane Hookom
Microsoft Access MVP

Im confused. Let me explain a little more. When I made the report I added a
Grouping level, Category, not sorting. Sorry. Im new to this. Now where would
I put the =Val(Category) ?? Sorry

As per Dave and my suggestion, use the sorting and grouping dialog in your
report design to reliably sort your report. When you enter the expression we
suggested, make sure you precede the expression with =.

You misunderstood what Duane was saying.
You can do this one of two ways depending on what you are doing. You stated

[quoted text clipped - 15 lines]

ABD... all the way to 15 - Repairs. When it is sorted its 1 - BBH 12 -
Housing 13 - Fuel... and so on. How can i make it 1, 2, 3, 4... ??

 

[stephendeloach via AccessMonster.com]

Works! Thanks so much for your help.

Go to the design view of your report. View the Sorting and Grouping dialog
box. Replace the [Category] with:
=Val([Category])

"Grouping" and "sorting" are about the same concept. You can sort without
creating groups but you can't create groups without sorting.

Im confused. Let me explain a little more. When I made the report I added a
Grouping level, Category, not sorting. Sorry. Im new to this. Now where would

[quoted text clipped - 8 lines]