 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / June 2005Multiple Line Items
I am using Access 2000. We have a dB to keep track of our quotes. One quote may have different line items. Each quote has a follow up date. I want to run a report that is based on follow up date (for each quote) that shows the Company information (name, who we talk to, tele#) the date we quoted the customer and the comments. I have the report, the only problem I have is that under each quote number it repeats all of the information I want for each line item. Example if a quote has 5 line items, under the quote number all of the information listed above is repeated 5 times. If the Quote has 2 line items, it repeats the information 2 times etc. How do I get the report to only list the information one time? Open the report in design mode and open the properties sheet. Now select the control(s) you are having problems with. On the "Format" tab of the property sheet is a property named "Hide Duplicates" --- by default it'll be set to "No" --- set it to "Yes" for those controls that you don't want repeated from line to line. You can be very creative with this and my experience shows that if you get too creative the report can be fairly difficult to read. It would be nice if there were a third option --- to print a double quote if the value is a duplicate. Bob. > I am using Access 2000. > We have a dB to keep track of our quotes. One quote may have different line [quoted text clipped - 7 lines] > it repeats the information 2 times etc. How do I get the report to only list > the information one time? >I am using Access 2000. >We have a dB to keep track of our quotes. One quote may have different line [quoted text clipped - 7 lines] >it repeats the information 2 times etc. How do I get the report to only list >the information one time? Use Sorting and Grouping (View menu) to specify a group on the quote id field. Select Yes for Group Header (and Footer?). Now move the text boxes for the Quote specific data to the group header section.  SignatureMarsh MVP [MS Access] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.