Prev: crosstab query with datea parameters
Next: Counting Combination Services
From: Mo on 9 Apr 2010 05:25
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.
From: Stefan Hoffmann on 9 Apr 2010 05:51
hi Mo,

On 09.04.2010 11:25, Mo wrote:
> 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 <--
From: Mo on 9 Apr 2010 05:58
On 09/04/2010 10:51, Stefan Hoffmann wrote:
> hi Mo,
>
> On 09.04.2010 11:25, Mo wrote:
>> 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.
 | 
Pages: 1
Prev: crosstab query with datea parameters
Next: Counting Combination Services