Finding data prefixed with '??'

[Mo]

I have a field in which some of the data that looks like this:

??/11/2009

I need to find all instances where this occurs. I tried using '*??* as
my criteria, but that appears to return all the records in my dataset.

Does anyone know what the correct criteria should be?

TIA.

 

[Stefan Hoffmann]

hi Mo,

I need to find all instances where this occurs. I tried using '*??* as
my criteria, but that appears to return all the records in my dataset.

The ? is a wild card for this type of search.

Does anyone know what the correct criteria should be?

You need to escape it: '*[?][?]*'

See also

http://office.microsoft.com/en-us/access/HA011715361033.aspx


mfG
--> stefan <--

 

[Mo]

hi Mo,

I need to find all instances where this occurs. I tried using '*??* as
my criteria, but that appears to return all the records in my dataset.

The ? is a wild card for this type of search.

Does anyone know what the correct criteria should be?

You need to escape it: '*[?][?]*'

See also

http://office.microsoft.com/en-us/access/HA011715361033.aspx


mfG
--> stefan <--

Thanks Stefan - just what I wanted.