Duplicate Query Entries...

[Kyosa]

I have a rather large query that returns contract vendors, effective dates, rates, etc. my problem is that i am using that as the basis for a report and only want the vendor listed one time. i've tried to use a group by (last,first etc ) and i still get dup entries OR if i use that last or first on the contract_Eff_Date field when i run my report it pops up a box asking for the contrcat eff date (like a parameter query). <br><br>can anyone help shed some light on what i may be doing wrong!!<br><br>thanks!<br>

 

[Guest_imported]

to have vendor show only one time!<br>On the report click on the vendor field and on properties under hide duplicates make sure it says yes.<br>not sure of reason for your other issue.

 

[Kyosa]

actually this was VERY stupid on my part...my, what a cup of coffee will do for you!!! basically, the query was working fine....it was when i pulled the report based on the query that it poped up the parameter box. <br><br>all i did was go to my report design and select those fields and change the control source to the LASTofeffdate...<br><br>hate it when it that happens.<br><br>

 

[DougP]

Why don't you use the group by properties in your report.<br><br>In design view of your report<br>click the &quot;View&quot; menu the &quot;Sorting and Grouping&quot;<br>Then choose &quot;vendor&quot; and in the &quot;Group Heading&quot; box put &quot;Yes&quot;<br>It will add a Group Header to your report <br>Put the Vendors text box in there and then it will show the vendors name once and all of their records below it<br>You can force each new vendor to a new page by clicking on the Vendor Gray heading bar in your report.<br>In the &quot;Force New page&quot; pick &quot;After Section&quot;<br><br>OK <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.