falcondeer
Registered User.
- Local time
- Yesterday, 17:21
- Joined
- May 12, 2013
- Messages
- 101
Thanks GasmanYou can make the criteria tempvars and set those?
PARAMETERS [TempVars]![Start] DateTime, [TempVars]![End] DateTime;
TRANSFORM Sum(TestTransactions.ID) AS SumOfID
SELECT TestTransactions.Description, TestTransactions.Category, TestTransactions.TransactionDate, Sum(TestTransactions.ID) AS [Total Of ID]
FROM TestTransactions
WHERE (((TestTransactions.TransactionDate) Between [tempvars]![start] And [tempvars]![end]))
GROUP BY TestTransactions.Description, TestTransactions.Category, TestTransactions.TransactionDate
PIVOT Format([TransactionDate],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
Thanks for the response but still don't know how ! I am not that expertYes, I don't see why not.
It is Normal to ask Twice because you have 2 criteria, the Start Date and the End Date.Could anybody help me figure out why my attached crosstab query asks for date range twice
YesThanks for the response but still don't know how ! I am not that expert
is it like in the attachment
@Minty@Gasman - you have to declare the parameters in a cross tab query, it won't work otherwise.
TRANSFORM Sum(TestTransactions.Amount) AS SumOfAmount
SELECT TestTransactions.Category, Sum(TestTransactions.Amount) AS [Total Of Amount]
FROM TestTransactions
WHERE (((TestTransactions.TransactionDate) Between [tempvars]![start] And [tempvars]![end]))
GROUP BY TestTransactions.Category
PIVOT Format([TransactionDate],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");