RE: [MS_AccessPros] Data type mismatch

 

Diane-

Switch to SQL View of your query and copy and paste the text. That will be much
easier for us to debug.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-------------------------------

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Diane
Sent: Wednesday, May 09, 2012 6:56 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Data type mismatch

 
I am trying to count how many times a category has some information in it such
as a TYPE column that has an M or F in it, I want to know how many times M or F
showed up. I keep getting a "Data type mismatch in criteria expression" error. I
don't know how to correct this. I am not very knowledgeable of expressions. Any
help would be appreciated. Thanks.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___