I am trying to upload the attached records from Excel into an Access database.
In Access I have constructed a report to print out "data only" for two vedors per page for IRS Form 1099-Misc. The problem.......Access returns two records per page of the SAME VENDOR. I need two different vendors per page. It returns two records, same vendor (a duplicate) same page.
Do I need to include a formula to "move to the next record"? Or is there an option in Access for this, for NO DUPLICATES.
I did try to upload my Access database, but this website said it was an "invalid file".
Bookmarks