Comparing fields that don't fall in same category [Archive]

View Full Version : Comparing fields that don't fall in same category

wensheng

09-24-03, 23:22

Hi, this is my first post, i need help on my problem [Excel 97, WinXP]

I need to compare fields in the xs with data in a access database. But these fields in the xs is not categorized properly, so how should i do it?¿
Take a look at the attachment below of the fields i mentioned:

Marvels

10-02-03, 12:57

SELECT Table1.Field, mid(Field,1,4) as compare
FROM Table1
where IsNumeric(mid(Field,1,4))

Here you select the info twice,
and (in this example)if in recordset field has the first 4 caracters that are number then it will select them

and with your result you can compare them to your other number

wensheng

10-02-03, 21:53

Originally posted by Marvels
SELECT Table1.Field, mid(Field,1,4) as compare
FROM Table1
where IsNumeric(mid(Field,1,4))

Here you select the info twice,
and (in this example)if in recordset field has the first 4 caracters that are number then it will select them

and with your result you can compare them to your other number

then can i ask one very simple question? i need to read values in a text box... but the values are seperated by commas!!!! i need to use sql query to compare... can i?