Parameter Error for Year 2010
Thanks Karl. It didn't work(syntax errors) but I get your logic.
"KARL DEWEY" wrote:
Try it this way --
PARAMETERS [Forms]![frmQtr]![txtEnterYr] Long;
.........
WHERE Year([TransDate]=[Forms]![frmQtr]![txtEnterYr]
--
Build a little, test a little.
"AccessKay" wrote:
Not sure if anyone knows the answer to this but I welcome any suggestions for
things to try. I have a crosstab query layered off of a Union query. I also
have a form with a text box for the user to choose the year and a command
button that pulls the report. It works fine if I choose the year 2009 or
earlier but if I choose 2010 I receive an error message, “…database engine
does not recognize “ as a valid field name or expression. I have not a clue
as to what is happening.
Thanks for any suggestions.
Here’s my query…if this helps any.
PARAMETERS [Forms]![frmQtr]![txtEnterYr] Text ( 255 );
TRANSFORM Sum(zqryforTotalsQTR.SumOfLbr_Total_Cost) AS
SumOfSumOfLbr_Total_Cost
SELECT zqryforTotalsQTR.Category, zqryforTotalsQTR.DGroup,
Format([TransDate],"yyyy") AS DYear,
Sum(zqryforTotalsQTR.SumOfLbr_Total_Cost) AS [Total Of SumOfLbr_Total_Cost]
FROM zqryforTotalsQTR
WHERE (((Format([TransDate],"yyyy"))=[Forms]![frmQtr]![txtEnterYr]))
GROUP BY zqryforTotalsQTR.Category, zqryforTotalsQTR.DGroup,
Format([TransDate],"yyyy")
PIVOT "Qtr " & Format([TransDate],"q");
|