Access Database Expert needed!
Budget: $100 – $500 USD
I need to be able to run a query on our orders database to have the orders display correctly. This will allow us to export to Excel and upload a .CSV to our shipping vendor. This will require a row of itemized items per order to be broken out by separate line items for each order based on the column name.
Example of our Access orders database:
Name Item A Item B
Fred Smith 1 3
Jane Jones 5 2
The query needs to display:
Fred Smith Item A 1
Fred Smith Item B 3
Jane Jones Item A 5
Jane Jones Item B 2
This is what we need in its simplest form. There will be address and weight information that will need to repeat for each line but it is all defined in tables.
Example of our Access orders database:
Name Item A Item B
Fred Smith 1 3
Jane Jones 5 2
The query needs to display:
Fred Smith Item A 1
Fred Smith Item B 3
Jane Jones Item A 5
Jane Jones Item B 2
This is what we need in its simplest form. There will be address and weight information that will need to repeat for each line but it is all defined in tables.