Create ASP report, pull data from Access
$100-300 USD
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #54621
Σχετικά με την εργασία
3 freelancers κάνουν προσφορές κατά μέσο όρο $240 για αυτή τη δουλειά
Hi !! I have given more details in your private message board. Thanks and Regards fuchsiasoft