D3 Access misbehaving?

I am running the following from a TCL prompt:

SORT JOBS WITH 2 = "1100" BY-DSND BOOK-DATE

Where :

2 is the name of the CUST# as defined in the MD
and ... 1100 is a valid customer number.

Result:

No Items Present

But, if I change the query as such:

SORT JOBS WITH 2 = "[1100" BY-DSND BOOK-DATE

it returns 61 hits, which is what I believe it should return. Can anyone
speculate as to why this is happening?

D3 running under W2K.


.

Relevant Pages

  • Re: D3 Access misbehaving?
    ... is the name of the CUST# as defined in the MD ... 1100 is a valid customer number. ... it returns 61 hits, which is what I believe it should return. ... to wonder if your file dict item "2" is somehow not working, ...
    (comp.databases.pick)
  • Re: D3 Access misbehaving?
    ... is the name of the CUST# as defined in the MD ... 1100 is a valid customer number. ... speculate as to why this is happening? ... Look at dict item "2" ...
    (comp.databases.pick)