List report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • HP Cummings
    New Member
    • Aug 2006
    • 3

    #1

    List report

    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
    Recognized Expert Top Contributor
    • Aug 2006
    • 1418

    #2
    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!

    Comment

    • PEB
      Recognized Expert Top Contributor
      • Aug 2006
      • 1418

      #3
      But it's very good as vision and you can manipulate it as a real Excel! ;)

      Comment

      • HP Cummings
        New Member
        • Aug 2006
        • 3

        #4
        Thanks
        @ @
        \___/

        Comment

        • HP Cummings
          New Member
          • Aug 2006
          • 3

          #5
          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

          Comment

          • PEB
            Recognized Expert Top Contributor
            • Aug 2006
            • 1418

            #6
            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! :)

            Comment

            Working...