InStr does not return position of $ symbol

[Guest]

InStr does not return position of $ symbol: InStr([Specifier],Chr(36)). How
else can I do this in an Access 2002 query?

 

[OfficeDev18 via AccessMonster.com]

It should work. What does the rest of the SQL look like?

Sam

InStr does not return position of $ symbol: InStr([Specifier],Chr(36)). How
else can I do this in an Access 2002 query?

 

[Brendan Reynolds]

It will work, provided that the field 'Specifier' does actually contain the
'$' character, rather than being formatted to appear as though it does.

What is the data type of the 'Specifier' field?

 

[John Spencer]

Is Specifier a number field or a currency field? If so, $ is NOT stored in
the field, it is just a display format and may be added when displaying the
data.

 

[Guest]

Hello Brendan,
Thank you very much for your quick reply which is much appreciated.
I have been away from home. Following your reply, I tried the same query on
another PC (same operating system and MS Access version), starting with a
blank database. No problem. I then tried the query on the backup of the
actual database. No problem. Upon my return I restored the database (which I
had since updated) and tried the query. No problem! I guess I shall never
know what caused this.
Thanks again for your help.
Best regards,
Ron

It will work, provided that the field 'Specifier' does actually contain the
'$' character, rather than being formatted to appear as though it does.

What is the data type of the 'Specifier' field?

--
Brendan Reynolds
Access MVP

InStr does not return position of $ symbol: InStr([Specifier],Chr(36)).
How
else can I do this in an Access 2002 query?

 

[Guest]

Hello Sam,
Thank you very much for your quick reply which is much appreciated.
I have been away from home. Following your reply, I tried the same query on
another PC (same operating system and MS Access version), starting with a
blank database. No problem. I then tried the query on the backup of the
actual database. No problem. Upon my return I restored the database (which I
had since updated) and tried the query. No problem! I guess I shall never
know what caused this.
Thanks again for your help.
Best regards,
Ron

It should work. What does the rest of the SQL look like?

Sam

InStr does not return position of $ symbol: InStr([Specifier],Chr(36)). How
else can I do this in an Access 2002 query?

 

[Guest]

Hello John,
Thank you very much for your quick reply which is much appreciated.
‘Specifier’ is a text field.
I have been away from home. Following your reply, I tried the same query on
another PC (same operating system and MS Access version), starting with a
blank database. No problem. I then tried the query on the backup of the
actual database. No problem. Upon my return I restored the database (which I
had since updated) and tried the query. No problem! I guess I shall never
know what caused this.
Thanks again for your help.
Best regards,
Ron

Is Specifier a number field or a currency field? If so, $ is NOT stored in
the field, it is just a display format and may be added when displaying the
data.

InStr does not return position of $ symbol: InStr([Specifier],Chr(36)).
How
else can I do this in an Access 2002 query?