Help with passing ASP variables to saved queries
- From: "tranceport185" <sbatschelet@xxxxxxxxx>
- Date: 23 Mar 2006 06:42:47 -0800
This Saved Access Query is called InnerJoinCategoryReport
SELECT InvLine.Cat, Sum(InvLine.Price) AS Total
FROM Payments INNER JOIN ((InvLine INNER JOIN Invoice ON InvLine.IId =
Invoice.IId) INNER JOIN PaySplit ON Invoice.IId = PaySplit.IId) ON
Payments.PAYId = PaySplit.PayId
WHERE (((Invoice.Total)=[Invoice].[Paid]) AND ((Payments.PayDate)
Between #"& dtStartDate &"# And #"& dtEndDate &"#))
GROUP BY InvLine.Cat
ORDER BY InvLine.Cat;
And is called by this query in ASP
SELECT POSCat.Description, InnerJoinCategoryReport.Total
FROM POSCat LEFT JOIN InnerJoinCategoryReport ON
InnerJoinCategoryReport.Cat=POSCat.Description;
I had to do it this way because Access seemed to get confused when I
tried to do the Left Join with the Inner Joins in the 1st query and
wouldn't run. My question is from ASP how can I have the variables
dtStartDate and dtEndDate setup so that it is read from ASP? I have
seen a couple examples but they were not this complex. BTW tested hard
coded dates work fine, thanks in advance.
-Sam
.
- Prev by Date: Append/copy calling a module switches data
- Next by Date: RE: Update Table Statement - Time Out Problem
- Previous by thread: Append/copy calling a module switches data
- Next by thread: RE: Update Table Statement - Time Out Problem
- Index(es):
Relevant Pages
|
