In Progress

Access Record Splitter

I have a client who has data like this in an access table:

itemID itemName itemQuantity

1 Corvette 1

2 Mustang 2

3 Camaro 5

He wants to append the data to another table so it looks like this:

itemID itemName itemQuantity

1 Corvette 1

2 Mustang 1

2 Mustang 1

3 Camaro 1

3 Camaro 1

3 Camaro 1

3 Camaro 1

3 Camaro 1

He needs it in this format so that he can export it to excel (for some unknown reason).

Is there an easy way to do this?

Skills: Microsoft Access

See more: excel access table, excel record, access append, record excel, append record table, splitter, data splitter, camaro, format table order export excel, format export excel php, access vba export filtered report excel, export excel oleobject access, access ole object vba export excel, export excel access drupal, access vba export excel format, php export excel format, export excel format, export excel file access database excel vba, access table, corvette, access export

About the Employer:
( 11 reviews ) Coral Gables, United States

Project ID: #4339752

Awarded to:

torajiv

Thanks for the invite. Certainly possible. Please send me the db. Regards Rajiv

$30 USD in 1 day
(54 Reviews)
5.4

4 freelancers are bidding on average $44 for this job

cheapexcell

Will be done in just 15 minutes

$30 USD in 0 days
(10 Reviews)
3.7
srdas2012

Hi, We are Expert in these ,Please check PMB

$65 USD in 5 days
(2 Reviews)
2.1
sunsoftpro

I am ready. Please send me file so that I am consider. Best regards!

$50 USD in 1 day
(0 Reviews)
0.0