Data type mismatch in criteria expression error returned...

  • Thread starter Thread starter Rashar Sharro via AccessMonster.com
  • Start date Start date
R

Rashar Sharro via AccessMonster.com

Hi,

I've tried putting single quotes around the * but am still getting the Data
type mismatch error.

How can I convert my field in my query to a text format?

Here is the script that produces this error:

IIf([tableName1]![FieldTarget]<>0,"*",0)

Thanks,

Robert
 
Rashar said:
Hi,

I've tried putting single quotes around the * but am still getting the Data
type mismatch error.

How can I convert my field in my query to a text format?

Here is the script that produces this error:

IIf([tableName1]![FieldTarget]<>0,"*",0)
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It'd be helpful to see the full query.

In the immediate case it seems you're trying to force a string ("*" and
the asterisk by itself, is a string) into a numeric column.

BTW, the separator punctuation between the table name and the column
name is a period NOT an exclamation point.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnKc74echKqOuFEgEQJPLgCeJ5Xxje6eRR+tfPENOxk5ePoPn4QAoL9n
DFzaJzTX3NyayrytuPCXJvgY
=q7Wb
-----END PGP SIGNATURE-----
 
Back
Top