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 [login to view URL] = [login to view URL]) ON
[login to view URL] = [login to view URL]) INNER JOIN cartRows ON
[login to view URL] = [login to view URL]) ON
[login to view URL] = [login to view URL]
WHERE ((([login to view URL])=2 Or ([login to view URL])=4) AND
(([login to view URL])=1));
Have purchased conference registration:
SELECT customers.*
FROM products INNER JOIN ((customers INNER JOIN (orders INNER JOIN
dbSessionCart ON [login to view URL] = [login to view URL]) ON
[login to view URL] = [login to view URL]) INNER JOIN cartRows ON
[login to view URL] = [login to view URL]) ON
[login to view URL] = [login to view URL]
WHERE ((([login to view URL])=2 Or ([login to view URL])=4) AND
(([login to view URL])=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.