Recent content by algioia

The client has their own software for any detailed information needed on their customer sales. We just need to house the invoice/sales data to be able to pull their sales by state/jurisdiction. We need the ship to information to see where the products were shipped so we can report the amount of...

Thank you for responding! The data is sales data, to be used for sales tax reporting. We will never use it to look up anything by a customer name or id, we would just use it for state and local jurisdiction sales reporting. If I use the Autonumber, would I be able to link the tables?

What do you suggest I use as the "common field" to link tables... if there is no particular customer id or unique information? The data will be used to run reports by either state, zip or city. Thanks in advance, annette

I need to learn Access again for some projects at work. I haven't touched it in 10 years and I cannot remember anything. I've spent hours upon hours working in it but I'm skipping around and not learning anything. :eek: So I ask you this... what would you suggest as the best way to learn the...

We receive client data monthly and it includes information on sales. I need to be able to import their data each month into a database and run a sales total for a particular jurisdiction in a state. For example, I need all sales for 1/1/08 through 12/31/08 in Houston, TX. I don't even know where...