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
|
|||
|
|||
how to do it alphabetically
hiii
i have the problem i have some products that i want to print them in report alphabetically such as the products start from character "A" should all be under it and so on i am using office 2003 thankx |
#2
|
|||
|
|||
how to do it alphabetically
Naveed
You may need to use the "Grouping & Sorting" feature to get your report to do alphabetic sorting. -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Naveed Pathan" wrote in message ... hiii i have the problem i have some products that i want to print them in report alphabetically such as the products start from character "A" should all be under it and so on i am using office 2003 thankx |
#3
|
|||
|
|||
how to do it alphabetically
thanx for the reply
but i how i have no idea about that guide me for that. thankx "Jeff Boyce" wrote: Naveed You may need to use the "Grouping & Sorting" feature to get your report to do alphabetic sorting. -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Naveed Pathan" wrote in message ... hiii i have the problem i have some products that i want to print them in report alphabetically such as the products start from character "A" should all be under it and so on i am using office 2003 thankx . |
#4
|
|||
|
|||
how to do it alphabetically
Naveed,
Go the Report in Design View. At the top below the Menu Bar there are buttons, one of the will say Grouping and Sorting. Click on that and then in the Window that opens select the field you want to Sort By, select Ascending. Close and Save... All done! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Naveed Pathan" wrote in message ... thanx for the reply but i how i have no idea about that guide me for that. thankx "Jeff Boyce" wrote: Naveed You may need to use the "Grouping & Sorting" feature to get your report to do alphabetic sorting. -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Naveed Pathan" wrote in message ... hiii i have the problem i have some products that i want to print them in report alphabetically such as the products start from character "A" should all be under it and so on i am using office 2003 thankx . |
#5
|
|||
|
|||
how to do it alphabetically
On Sun, 3 Jan 2010 12:37:38 -0500, "Gina Whipp"
wrote: Go the Report in Design View. At the top below the Menu Bar there are buttons, one of the will say Grouping and Sorting. Click on that and then in the Window that opens select the field you want to Sort By, select Ascending. Close and Save... All done! Yes. And if you want a *header* with all the products that start with A (which I inferred from your phrasing "such as the products start from character "A" should all be under it"), then you can create a grouping header using a calculated expression like Left(MyProductName, 1). Armen Stein Microsoft Access MVP www.JStreetTech.com |
#6
|
|||
|
|||
how to do it alphabetically
thanks all of you
especially you got my point that what i really mean but i can't do that could you please guide me from a to z to get it done thankx "Armen Stein" wrote: On Sun, 3 Jan 2010 12:37:38 -0500, "Gina Whipp" wrote: Go the Report in Design View. At the top below the Menu Bar there are buttons, one of the will say Grouping and Sorting. Click on that and then in the Window that opens select the field you want to Sort By, select Ascending. Close and Save... All done! Yes. And if you want a *header* with all the products that start with A (which I inferred from your phrasing "such as the products start from character "A" should all be under it"), then you can create a grouping header using a calculated expression like Left(MyProductName, 1). Armen Stein Microsoft Access MVP www.JStreetTech.com . |
#7
|
|||
|
|||
how to do it alphabetically
Naveed,
At which part did you get stuck? Did you find the Grouping and Sorting? Or perhaps how to add a Header for the letters? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Naveed Pathan" wrote in message ... thanks all of you especially you got my point that what i really mean but i can't do that could you please guide me from a to z to get it done thankx "Armen Stein" wrote: On Sun, 3 Jan 2010 12:37:38 -0500, "Gina Whipp" wrote: Go the Report in Design View. At the top below the Menu Bar there are buttons, one of the will say Grouping and Sorting. Click on that and then in the Window that opens select the field you want to Sort By, select Ascending. Close and Save... All done! Yes. And if you want a *header* with all the products that start with A (which I inferred from your phrasing "such as the products start from character "A" should all be under it"), then you can create a grouping header using a calculated expression like Left(MyProductName, 1). Armen Stein Microsoft Access MVP www.JStreetTech.com . |
#8
|
|||
|
|||
how to do it alphabetically
On Mon, 4 Jan 2010 02:24:01 -0800, Naveed Pathan
wrote: thanks all of you especially you got my point that what i really mean but i can't do that could you please guide me from a to z to get it done thankx Hi Naveed, Other responders may be more willing to explain everything out in detail, step by step, but I take the approach to give you ideas and get you started in the right direction. As Gina says, if you tell us exactly what you are trying to do, what you have tried, and where you are stuck, we'll be able to help you with the next steps. Armen Stein Microsoft Access MVP www.JStreetTech.com |
Thread Tools | |
Display Modes | |
|
|