MS Acess help!!!!

rewindurmind · 01-27-2008, 04:08 AM

In Microsoft Access, I currently have a select query in which the criteria for records is that their DateOfInvoice lies between two dates. The SQL for this query is:

Code:

SELECT Count(qryTotalCost.InvoiceID) AS TotalJobs, Sum(qryTotalCost.Net) AS TotalRevenue, Avg(qryTotalCost.Net) AS AverageRevenue 
 FROM qryTotalCost INNER JOIN tblJob ON qryTotalCost.InvoiceID = tblJob.InvoiceID 
 HAVING (((tblJob.DateOfInvoice)>=[What date would you like to start from?] And (tblJob.DateOfInvoice)<=[What date would you like to finish at?]));

As you can see, the user enters two dates and the system (correctly, without errors) displays all records which I can then put into a report, et cetera.

My problem is this: is there any way to store these two date parameters which can then themselves be inserted into a report or similar? I can't seem to find a way for the system to actually store these values that the user types in.

Many thanks!

01-27-2008, 04:08 AM	#1 (permalink)
rewindurmind Registered User Join Date: Oct 2007 Posts: 13 OS: xp service pack 2	MS Acess help!!!! In Microsoft Access, I currently have a select query in which the criteria for records is that their DateOfInvoice lies between two dates. The SQL for this query is: Code: SELECT Count(qryTotalCost.InvoiceID) AS TotalJobs, Sum(qryTotalCost.Net) AS TotalRevenue, Avg(qryTotalCost.Net) AS AverageRevenue FROM qryTotalCost INNER JOIN tblJob ON qryTotalCost.InvoiceID = tblJob.InvoiceID HAVING (((tblJob.DateOfInvoice)>=[What date would you like to start from?] And (tblJob.DateOfInvoice)<=[What date would you like to finish at?])); As you can see, the user enters two dates and the system (correctly, without errors) displays all records which I can then put into a report, et cetera. My problem is this: is there any way to store these two date parameters which can then themselves be inserted into a report or similar? I can't seem to find a way for the system to actually store these values that the user types in. Many thanks!