View Single Post
  #2  
Old May 27th, 2010, 08:55 PM posted to microsoft.public.access.queries
AccessKay
external usenet poster
 
Posts: 106
Default 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");