Create ASP report, pull data from Access

Ακυρώθηκε Αναρτήθηκε Apr 11, 2006 Πληρώθηκε κατά την παράδοση
Ακυρώθηκε Πληρώθηκε κατά την παράδοση

I've uploaded an Excel report I need generated in ASP from the attached Access database. The Comersus (ASP ecommerce package) database has a fairly complex structure, but free support can be found by visiting the forums at www.comersus.com. In the DB, product id=1 is SDVSHO membership. Product id=3 is conference registration.

The following queries may be of some assistance:

Have purchased membership:

SELECT customers.*

FROM products INNER JOIN ((customers INNER JOIN (orders INNER JOIN

dbSessionCart ON [url removed, login to view] = [url removed, login to view]) ON

[url removed, login to view] = [url removed, login to view]) INNER JOIN cartRows ON

[url removed, login to view] = [url removed, login to view]) ON

[url removed, login to view] = [url removed, login to view]

WHERE ((([url removed, login to view])=2 Or ([url removed, login to view])=4) AND

(([url removed, login to view])=1));

Have purchased conference registration:

SELECT customers.*

FROM products INNER JOIN ((customers INNER JOIN (orders INNER JOIN

dbSessionCart ON [url removed, login to view] = [url removed, login to view]) ON

[url removed, login to view] = [url removed, login to view]) INNER JOIN cartRows ON

[url removed, login to view] = [url removed, login to view]) ON

[url removed, login to view] = [url removed, login to view]

WHERE ((([url removed, login to view])=2 Or ([url removed, login to view])=4) AND

(([url removed, login to view])=3));

Basically in the attached report, you'll need the query above, and will need to tie it to the tables cartRows and cartRowsOptions.

Also uploaded is a MS Word document with a to-do list. The items that have been crossed out I have already completed. Let me know if you need me to expand on any of the items. It will be easier to understand once you can see the ASP code, but this should give you a good idea of what is going to be required.

Thank you for your interest, and I look forward to the quotes.

ASP Επεξεργασία Δεδομένων

Ταυτότητα Εργασίας: #54621

Σχετικά με την εργασία

3 προτάσεις Απομακρυσμένη εργασία Ενεργό May 5, 2006

3 freelancers κάνουν προσφορές κατά μέσο όρο $240 για αυτή τη δουλειά

elfuerte

Check PMB for more information.

$200 USD σε 0 μέρες
(3 Αξιολογήσεις)
4.1
fuchsiasoft

Hi !! I have given more details in your private message board. Thanks and Regards fuchsiasoft

$221 USD σε 1 μέρα
(10 Αξιολογήσεις)
3.9