Report based on selected categories.

[Bob Lin]

I am helping one of my clients to setup a network. He asked me how to view
or print a report based on one of categories.



He has a contact table and each contact is assigned a certain category such
as business, vendor, client. He would like the report to give him the option
to select one category and list all contacts belonging to the category. How
can he do this?



Robert Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN, Anti-Virus, Tips & Troubleshooting on
http://www.ChicagoTech.net
This posting is provided "AS IS" with no warranties.

 

[Fons Ponsioen]

The simplest would be to create the report based on a
query. Than in the query design view place in the
criteria for the category type [Enter category] with the
square brackets. Now each time the query or report is run
the user will be tempted to enter the category. Note:
doing this requires the user to type in the entire word
such as VENDOR. alternitively you may type in the
criteria filed "like *[Enter Category]*" (without the dbl
quotes) this would allow the user to type in part of the
word, for instance "ve" for vendor or "cli" for client.
Hope this helps.
Fons

 

[Bob Lin]

Fons,

Thank you for the help. I will try that and will post it back. But, can he
create a list box instead of typing so that he can select a category?

Robert Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN, Anti-Virus, Tips & Troubleshooting on
http://www.ChicagoTech.net
This posting is provided "AS IS" with no warranties.

The simplest would be to create the report based on a
query. Than in the query design view place in the
criteria for the category type [Enter category] with the
square brackets. Now each time the query or report is run
the user will be tempted to enter the category. Note:
doing this requires the user to type in the entire word
such as VENDOR. alternitively you may type in the
criteria filed "like *[Enter Category]*" (without the dbl
quotes) this would allow the user to type in part of the
word, for instance "ve" for vendor or "cli" for client.
Hope this helps.
Fons

-----Original Message-----
I am helping one of my clients to setup a network. He asked me how to view
or print a report based on one of categories.



He has a contact table and each contact is assigned a certain category such
as business, vendor, client. He would like the report to give him the option
to select one category and list all contacts belonging to the category. How
can he do this?



Robert Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN, Anti-Virus, Tips & Troubleshooting on
http://www.ChicagoTech.net
This posting is provided "AS IS" with no warranties.


.