By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,738 Members | 1,463 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,738 IT Pros & Developers. It's quick & easy.

Criteria for a crosstab query

P: 5
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.
Jan 18 '07 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 18 '07 #2

P: 5
Hi

Thanks for the tip. It worked.

Tererai
Feb 9 '07 #3

P: 5
Expand|Select|Wrap|Line Numbers
  1. PARAMETERS [month and year] Text ( 255 );
  2. TRANSFORM Sum(qryJoining.Item_Cost) AS SumOfItem_Cost
  3. SELECT qryJoining.DEPOT, qryJoining.Fleet_No, Sum(qryJoining.Item_Cost) AS [Total Of Item_Cost]
  4. FROM qryJoining
  5. GROUP BY qryJoining.DEPOT, qryJoining.Fleet_No
  6. ORDER BY qryJoining.DEPOT, qryJoining.Fleet_No
  7. PIVOT qryJoining.Item_ID;
  8.  
Feb 9 '07 #4

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

Expand|Select|Wrap|Line Numbers
  1. PARAMETERS [month and year] Text ( 255 );
  2. TRANSFORM Sum(qryJoining.Item_Cost) AS SumOfItem_Cost
  3. SELECT qryJoining.DEPOT, qryJoining.Fleet_No, Sum(qryJoining.Item_Cost) AS [Total Of Item_Cost]
  4. FROM qryJoining
  5. GROUP BY qryJoining.DEPOT, qryJoining.Fleet_No
  6. ORDER BY qryJoining.DEPOT, qryJoining.Fleet_No
  7. PIVOT qryJoining.Item_ID;
  8.  
Feb 9 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.