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

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

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



.

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



.

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

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

.

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

.

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