how to do it alphabetically

  • Thread starter Thread starter Naveed Pathan
  • Start date Start date
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
 
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.
 
thanx for the reply
but i how i have no idea about that guide me for that. 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
 
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!
Click to expand...

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
 
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
Click to expand...

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
 
Back
Top