using crosstab query text

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » Using a Crosstab Query with Text as the Value | Access forum

Using a Crosstab Query with Text as the Value | Access forum

resolvedResolved · High Priority · Version 2003

Francesco has attended:
Outlook Advanced course

Using a Crosstab Query with Text as the Value

Hi,
I'm trying to create a Crosstab Query but I get a 'Data Type Mismatch in Criteria Expression' error because the value field for the Crosstab is non-numeric. How do can I do a Crosstab Query with a Text field as the value? I have only one record per column/row match.

RE: Using a Crosstab Query with Text as the Value

Dear Francesco

Thank you for your query!

I would appreciate if you could provide me with an example so that I can try to visualise your query!!

Normally in Access when you create Cross tab query you have Row and Column headings. You can have up to three columns headings.

If you are using the Cross tab query wizard in the step you choose the field you would like to have calculation performed you would normally choose the text functions such as Count, etc...

I don't know if you are aware that there is Pivot table functionality in Access. May be that could resolve your query!

Please refer to the following link about Pivot Tables in Access:

http://office.microsoft.com/en-us/access/HA010345801033.aspx

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT


 

Access articles

Please browse our web site to find out more about
training for microsoft access and other training courses.

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.