Setting a date criteria for crosstab query

[techkenny1]

Hi
Below is the sql code for a crosstab query;

TRANSFORM Sum(Accounts08.InvoiceTotal) AS SumOfInvoiceTotal
SELECT Accounts08.Companyname, Sum(Accounts08.InvoiceTotal) AS [Total Of InvoiceTotal]
FROM Accounts08
GROUP BY Accounts08.Companyname
PIVOT Format([DateRaised],"mmm-yyyy");

I need to be able to select a date ie; 1/7/10 to 31/7/10 to show sales per company for that date period.

many thanks

kp

 

[dhookom]

You should create a form and add a couple text boxes to enter the start and end dates. With crosstabs, you must select the data type of all parameters/criteria.

Select Query->Parameters
Enter your parameters
Set their data type

Duane
Hook'D on Access
MS Access MVP