How to retrieve data which contain "/" in it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I try to pull a data from access with contain a speacial character "/" in it
but what i get is it not return a single data, so how do i wanna retrieve it?

below is statement I use it but it return nothing.

SELECT LDDATA.COR, LDDATA.CON, LDDATA.PCODE, LDDATA.QTY, LDDATA.BOXNO,
LDDATA.CASENO, LDDATA.RSNOS, LDDATA.RSNOE, LDDATA.NOFRS
FROM LDDATA WHERE (((LDDATA.COR)="A11/LC/000002/11/06")) ORDER BY
LDDATA.CON, LDDATA.BOXNO;
 
Hi,
I try to pull a data from access with contain a speacial character "/" in it
but what i get is it not return a single data, so how do i wanna retrieve it?

below is statement I use it but it return nothing.

SELECT LDDATA.COR, LDDATA.CON, LDDATA.PCODE, LDDATA.QTY, LDDATA.BOXNO,
LDDATA.CASENO, LDDATA.RSNOS, LDDATA.RSNOE, LDDATA.NOFRS
FROM LDDATA WHERE (((LDDATA.COR)="A11/LC/000002/11/06")) ORDER BY
LDDATA.CON, LDDATA.BOXNO;
Click to expand...

Is COR perhaps a Lookup field to another table? If so, it does not contain the
text string which it appears to contain, but rather a number linking to the
lookup table.

If COR is in fact a Text field within this table, then all I can suggest is
that there is no record with this exact value. What do you see when you open
the table datasheet and see what's in the COR field?

John W. Vinson [MVP]
 
Hi John,

The COR is text field in database and I have pump a sample data into it
which is one of it is A11/LC/000002/11/06. when i change COR to CON which is
number field in database it return me correct info, i assume that i need to
look at "/" so that database know that it part of the data, but I' not sure
yet, is that possible cause ??
 
Hi John,

The COR is text field in database and I have pump a sample data into it
which is one of it is A11/LC/000002/11/06. when i change COR to CON which is
number field in database it return me correct info, i assume that i need to
look at "/" so that database know that it part of the data, but I' not sure
yet, is that possible cause ??
Click to expand...

The / character has NOTHING to do with the problem.

I have *no* idea how your table is structured, nor what you mean by your
changing COR to CON.

Please post the names and datatypes of the fields in your query, and the
complete SQL string that you're using to search. A couple of rows of sample
data will be helpful as well.

John W. Vinson [MVP]
 
Back
Top