No Duplicate Vendor #s

[access2010]

Hello, I have to produce a long report and would like to show each Vendor number only once.
.
I have tried many suggestions without success.
.
Your ides will be appreciated
.
Lisa

 

[Trevor G]

Lisa your file cannot be downloaded. Try this. When you start a Report use the Wizard then as you select your Table/Query then Next stage should ask you to Group and you select your Vendor Field then simply complete the rest of your report and it should Group for you. If this fails uploaded a zipped copy of the database.

 

[access2010]

Hello and thank you for your suggestion.
.
I have again tried creating New Queries and New Reports, but without success
.
I would like to see only one unique vendor number such as;
A-1088
A-1106
B-1002
.
Instead of 5 or more multiple lines for each vendor number
.
I am using MS Access 2003 as our charity's database
.
Your help will be appreciated
.
Lisa

 

[stopher]

In your query (record source) you have set "Group By" for Vendor#,Vendor Name and VendorInvoiceDate. You need to set VendorInvoiceDate to "Where" not "Group By". Only Vendor# and Vendor Name should be group by.

 

[access2010]

Thank you for your suggestion, but I am still receiving multiple records for each vendor, while I would like to see only 1 record for each vendor.
.
SELECT VendorPayables.[Vendor#], VendorPayables.VendorInvoiceNo
FROM VendorPayables LEFT JOIN Vendors ON VendorPayables.[Vendor#] = Vendors.[Vendor#]
GROUP BY VendorPayables.[Vendor#], VendorPayables.VendorInvoiceNo;
.
Please advise me as to what I am doing wrong?
.
Thanks / Lisa

 

[stopher]

Thank you for your suggestion, but I am still receiving multiple records for each vendor, while I would like to see only 1 record for each vendor.
.
SELECT VendorPayables.[Vendor#], VendorPayables.VendorInvoiceNo
FROM VendorPayables LEFT JOIN Vendors ON VendorPayables.[Vendor#] = Vendors.[Vendor#]
GROUP BY VendorPayables.[Vendor#], VendorPayables.VendorInvoiceNo;
.
Please advise me as to what I am doing wrong?
.
Thanks / Lisa

Remove VendorInvoiceNo like this:

SELECT VendorPayables.[Vendor#]
FROM VendorPayables LEFT JOIN Vendors ON VendorPayables.[Vendor#] = Vendors.[Vendor#]
GROUP BY VendorPayables.[Vendor#];