openreport

have a Access 2003 Database that is also used by 2000 and 2002 users. I
have report that I would like to make available for my teammembers.
Teammembers would like to have the ability to sort by one or more fields.
There are five fields i.e. SN#, CustomerName, SalesRep, SalesArea, & Status.
My idea was that I could create a form that they would open and maybe select
one or more of the fields for example they could select sort by
SalesRep/Asending, then sort by Status, then by CustomerName. Then select
report from Drop Down Menu. Then click okay to openreport for preview. The
report will reflect the choices made by user.

OR

Maybe from the form select the report and a list of fields show up in 5
combo boxes i.e. Sort first by.... Then by....
Then by.....

Then the user click Preview Report command button and the reports open.

There is a solution at Allen Browne's page
http://allenbrowne.com/ser-33.html.

--
Duane Hookom
MS Access MVP
--

"Tricia Young" wrote in message
...
have a Access 2003 Database that is also used by 2000 and 2002 users. I
have report that I would like to make available for my teammembers.
Teammembers would like to have the ability to sort by one or more fields.
There are five fields i.e. SN#, CustomerName, SalesRep, SalesArea, &
Status.
My idea was that I could create a form that they would open and maybe
select
one or more of the fields for example they could select sort by
SalesRep/Asending, then sort by Status, then by CustomerName. Then select
report from Drop Down Menu. Then click okay to openreport for preview.
The
report will reflect the choices made by user.

OR

Maybe from the form select the report and a list of fields show up in 5
combo boxes i.e. Sort first by.... Then by....
Then by.....

Then the user click Preview Report command button and the reports open.