Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004

    Unhappy Unanswered: Postcode problem!

    Hi All

    I have an access db with two tables.
    One table has a number of fields, one of which is a field of postcodes.

    the other table has the outcode of the postcode (1st part) And a value in the next column which is a price to deliver there.

    I need a update query which updates a currently empty [price] column in the big table with the value from the postcode table if the PARTIALLY matches the 1st part of the postcode.

    I was thinking of an update query but i cant figure out how to set the criteria to update when there is a partial match on the characters!

    any help would be great

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    use left([columnname],nochars) for a patial match

    where left([table1].[postcode],2) =left([table2].[postcode],2)

  3. #3
    Join Date
    Nov 2004


    Thats great!

    Also is there a way for the user to specify the table name from a input box?
    ie if the table name changes or a new one is used but i wanted the user not to have to amend the sql code?


Posting Permissions

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