• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Query # sign in Access ODBC

M

mmaki

Member
I'm trying to query the # sign from a recordset. For example I want to find all the records equal to # 31. I understand the # is a reserved symbol, and to use it in a query it should be bracketed [#]. I've tried several combinations of syntax but no luck. I can do it with an Access query, but when I copy the SQL to my FrontPage query it fails. Message returned was an error with my SQL statement. If I submit the same query without the [#] it will return the records for the number alone. Any ideas?

Thanks.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top