InStr does not return position of $ symbol

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

InStr does not return position of $ symbol: InStr([Specifier],Chr(36)). How
else can I do this in an Access 2002 query?
 
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?
Click to expand...
 
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?
 
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.
 
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


Brendan Reynolds said:
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

Ron - CLH said:
InStr does not return position of $ symbol: InStr([Specifier],Chr(36)).
How
else can I do this in an Access 2002 query?
Click to expand...
Click to expand...
 
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


OfficeDev18 via AccessMonster.com said:
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?
Click to expand...
Click to expand...
 
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


John Spencer said:
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.




Ron - CLH said:
InStr does not return position of $ symbol: InStr([Specifier],Chr(36)).
How
else can I do this in an Access 2002 query?
Click to expand...
Click to expand...
 
Back
Top