Connecting Tech Pros Worldwide Forums | Help | Site Map

List report

Newbie
 
Join Date: Aug 2006
Posts: 3
#1: Aug 31 '06
I have a data base and need to run a report that will allow me to select certain customers and list only them, not show all of our customers. :confused:
PEB's Avatar
PEB PEB is offline
Expert
 
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#2: Aug 31 '06

re: List report


So You shouldn't use the report form to do it!
It's better to use Form or Query sown in Pivot table view! There you have the opportunity to profite of those options!

From View you select Pivottable View and then you customize your report! :)

But be patient! It's running slow! Very slowly!
PEB's Avatar
PEB PEB is offline
Expert
 
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#3: Aug 31 '06

re: List report


But it's very good as vision and you can manipulate it as a real Excel! ;)
Newbie
 
Join Date: Aug 2006
Posts: 3
#4: Aug 31 '06

re: List report


Thanks
@ @
\___/
Newbie
 
Join Date: Aug 2006
Posts: 3
#5: Sep 5 '06

re: List report


Quote:

Originally Posted by PEB

So You shouldn't use the report form to do it!
It's better to use Form or Query sown in Pivot table view! There you have the opportunity to profite of those options!

From View you select Pivottable View and then you customize your report! :)

But be patient! It's running slow! Very slowly!

Hi there, remember me? I cant get what I need, Im pretty sure I dont know how to ask it for what I need. Can you help? I have a table, and I need to be able to lets say pick 75 of my 3800 entries and have their information print on a report.
I would appreciate any type of clue. I have experience working in access, but not creating new reports.
@ @
\___/ thanks
PEB's Avatar
PEB PEB is offline
Expert
 
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#6: Sep 5 '06

re: List report


Hi,

If the first suggestion didn't help you so reelly the next you can do is to add a column from type true or false with caption to_print

When the user fill in this check the information for the respective client will be included, when it is empty or false the information for your customer won't appear!

So you have to add this column in your form as check box. In the form you can put an option to check in all or to check out all! Those commands will be activated by on click expression to respective butons that run Update queries!

When you are ready with those steps as recordset source you assign your table with ccustomers and as a condition you have to mention that to_print=True

So only the wanted information from your form will appear...

When you change your choice for the customers you have to close and reopen your report :)

Hope that this suggestion will please you! :)
Reply


Similar Microsoft Access / VBA bytes