[AccessD] Using # in a query.

Darryl Collins darryl at whittleconsulting.com.au
Sun Mar 25 18:38:32 CDT 2012


Steve!

That works great, Thanks so much - I had tried a few syntax's, but that wasn't one of them.

Cheers
Darryl!

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Monday, 26 March 2012 10:11 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Using # in a query.

Darryl

Like "[#]*"

Regards
Steve

-----Original Message-----
From: Darryl Collins
Sent: Monday, March 26, 2012 11:59 AM
To: Access Developers discussion and problem
solving(accessd at databaseadvisors.com)
Subject: [AccessD] Using # in a query.

Hi folks,

Blonde moment, this seems simple enough, but I cannot get it to behave today.

I have a table with a field that contains text (string) which some of the records start with a hash (for example  "#Input", "#Output" and the rest of them don't "Delivery" for instance).

I am trying to write a query along the lines of LIKE "#*" so I can isolate just the entries that begin with #, but as # is used in other ways in Access (and in queries too) I cannot get it to work.

Anyone shine some light on this one?

Cheers
Darryl.



Darryl Collins
Whittle Consulting Pty Ltd
Suite 8, 660 Canterbury Rd
Surrey Hills, VIC, 3127

p: +61 3 9898 3242
m: +61 418 381 548
f: +61 3 9898 1855
e: darryl at whittleconsulting.com.au<mailto:darryl at whittleconsulting.com.au>
w: www.whittleconsulting.com.au<http://www.whittleconsulting.com.au/>

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list