Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access-training-courses - Queries

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access-training-courses - Queries

Resolved · Low Priority · Version Standard

Reply Wed 7 Nov 2007, 20:09Delegate Margaret said...

Margaret has attended:
No courses

Queries

When I enter " " around a text word to have the query only display that information, I receive a message that the criteria does not match. I noticed in the design page that I had this listed as a number but it is text. I can't change it now as there are many relationships to many tables. So, how can I get this to be accepted and run the query?

For upcoming training course dates see: Pricing & availability

Reply Thu 8 Nov 2007, 15:49Trainer Anthony said...

RE: Queries

Hi Margaret:

If the field is shown as a Number data type in Table Design view, then it will only accept numeric data, not text data.

Thus, in a Query Criteria you have to enter a numeric value. A number enclosed in quotes - "123" - will not work, you will get a Data Type Mismatch Error message. You need to enter the number without the quotes.

Regards,

Tony

Reply Thu 8 Nov 2007, 16:59Delegate Margaret said...

RE: Queries

Thanks Tony, When I enter it with no quotes, Access adds the quotes then gives me the same error. M

Reply Mon 19 Nov 2007, 08:26Trainer Pete said...

RE: Queries

Hi Margaret, perhaps you could post your 'criteria' line so that we can have a quick look and see if there is anything that could be 'tweaked' to help with your problem, look forward to hearing from you, regards Pete

Reply Mon 19 Nov 2007, 13:56Delegate Margaret said...

RE: Queries

Hi,
Thanks Pete but this is confidential work as I am the data analyst in a Quality Management Department. I think I solved the problem and will let you know if not. Thanks again, Margaret

Access articles

· Microsoft Access: Unleash the True Potential Today
· It Is Important To Take Care Over Primary Key Assignment
· Why Do I Need To Use Access?
· Help Business To Go Global With Shared Databases
· Sub-reports And Sub-forms In Access 2007

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips