Find Jobs
Hire Freelancers

343273 MS Access programming

N/A

Dalam Kemajuan
Disiarkan lebih dari 14 tahun yang lalu

N/A

Dibayar semasa penghantaran
I need somebody to write some code/query for an existing Access database. The coding needs to work for both 2003 and 2007. I have a table, which has invoice data, and each record can have upto 9 seperate products/qty/prices on the record (e.g., [product1][qty1][product2][qty2] etc) I need to output this as a CSV file, to import into Sage (an accounts program). I'm running a query, and then in datasheet view, saving this as a delimited text file. All works well. Here is the problem. Sage doesn't allow a line of the CSV to include more than one product/qty/price etc, but my record has up to 7 different products/quantities/prices The way Sage works, is that you must import the record a second/third/fourth time - keeping the invoice number the same - but change the product details, and then Sage appends all of the rows that share the same invoice number onto one 'Sage invoice'. So, I need a query (or soemthing) that displays a record in datasheet view, then re-displays the same record a line below where the criteria justifies it? Eg, if qty2>0 E.g., in datasheets i want... ABC Ltd inv12345 10/1/09 Widgets 10.00 1 ABC Ltd inv12345 10/1/09 Donuts 12.00 1 ... where the above comes from the same record. The only way i can think of doing it is to run 7 seperate queries (one for each product line) and then merge the resulting datasheets afterwards. However, it doesn't have to be done like this - if you can think of a better way, then that would be fine. The result needs to be one CSV file.
ID Projek: 2089093

Tentang projek

Projek jarak jauh
Aktif 12 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan

Tentang klien

Bendera
5.0
8
Ahli sejak Dis 12, 2007

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.