ok maybe I didn't explain this well. I am new to working with databases. Pretty much I have two tables one customer table and one sales table. The sales table has all the invoices in it. I am trying to automate a rebate system for one of our vendors. I need a report that lists invoices by...
I need to make a report from a query. The query is set up like
key invoice date prod part
I need to get a count of how many invoices there are not counting duplicates. Any ideas?
I am pretty new to Access so I am sorry if I get any terms wrong and what not.
My problem is that I need to set up a macro or something to automaticly delete two tables and then import 2 tables from an ODBC database. I need to make this as userfriendly as possible. I can't get it to delete...