how to do it alphabetically

N

Naveed Pathan

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
 
J

Jeff Boyce

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.
 
N

Naveed Pathan

thanx for the reply
but i how i have no idea about that guide me for that. thankx
 
G

Gina Whipp

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
 
A

Armen Stein

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
 
N

Naveed Pathan

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
 
A

Armen Stein

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top