Criteria for a crosstab query

[Tererai]

Hi guys? I am new to this community, i'm very pleased to join you.

For the past 2 weeks i have been trying to specify criteria in a crosstab query but i get a fun message which says"Microsoft Jet Database does not recognize whatever criteria i would have specified as valid field name or expression."

I am stuck and don't know what to do next.

[MMcCarthy]

Hi guys? I am new to this community, i'm very pleased to join you.

For the past 2 weeks i have been trying to specify criteria in a crosstab query but i get a fun message which says"Microsoft Jet Database does not recognize whatever criteria i would have specified as valid field name or expression."

I am stuck and don't know what to do next.

Hi Tererai

Welcome to thescripts.

Change your query view to SQL and copy and paste the query in here.

Mary

[Tererai]

Hi

Thanks for the tip. It worked.

Tererai

[Tererai]

PARAMETERS [month and year] Text ( 255 );
TRANSFORM Sum(qryJoining.Item_Cost) AS SumOfItem_Cost
SELECT qryJoining.DEPOT, qryJoining.Fleet_No, Sum(qryJoining.Item_Cost) AS [Total Of Item_Cost]
FROM qryJoining
GROUP BY qryJoining.DEPOT, qryJoining.Fleet_No
ORDER BY qryJoining.DEPOT, qryJoining.Fleet_No
PIVOT qryJoining.Item_ID;

[Tererai]

I finally figured out where i went wrong.Now have the query up and running and i have pasted the SQL format below.

PARAMETERS [month and year] Text ( 255 );
TRANSFORM Sum(qryJoining.Item_Cost) AS SumOfItem_Cost
SELECT qryJoining.DEPOT, qryJoining.Fleet_No, Sum(qryJoining.Item_Cost) AS [Total Of Item_Cost]
FROM qryJoining
GROUP BY qryJoining.DEPOT, qryJoining.Fleet_No
ORDER BY qryJoining.DEPOT, qryJoining.Fleet_No
PIVOT qryJoining.Item_ID;