If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
grouping
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... ?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#2
|
|||
|
|||
grouping
The report is sorting as designed. You might try change the sorting and
grouping expression to: =Val([Category]) -- Duane Hookom Microsoft Access MVP "stephendeloach via AccessMonster.com" wrote: 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... ?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#3
|
|||
|
|||
grouping
That still didnt work... Any other suggestions? Thanks
Duane Hookom wrote: 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... ?? -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
grouping
"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 "stephendeloach via AccessMonster.com" wrote: That still didnt work... Any other suggestions? Thanks Duane Hookom wrote: 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... ?? -- Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
grouping
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... Duane Hookom wrote: "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... ?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#6
|
|||
|
|||
grouping
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 "stephendeloach via AccessMonster.com" wrote: 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... Duane Hookom wrote: "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... ?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#7
|
|||
|
|||
grouping
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 "Klatuu" wrote: 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 "stephendeloach via AccessMonster.com" wrote: 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... Duane Hookom wrote: "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... ?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#8
|
|||
|
|||
grouping
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 Duane Hookom wrote: 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... ?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#9
|
|||
|
|||
grouping
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 "stephendeloach via AccessMonster.com" wrote: 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 Duane Hookom wrote: 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... ?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#10
|
|||
|
|||
grouping
Works! Thanks so much for your help.
Duane Hookom wrote: 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] 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... ?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
Thread Tools | |
Display Modes | |
|
|