Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Unanswered: Comparing fields that don't fall in same category

    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:
    Attached Thumbnails Attached Thumbnails forumpic.bmp  
    There no other place better than this... http://wenz.alexlab.com

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    is this what your looking 4

    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

  3. #3
    Join Date
    Sep 2003
    Posts
    12

    Re: is this what your looking 4

    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?
    There no other place better than this... http://wenz.alexlab.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •