Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Malaysia
    Posts
    7

    Unanswered: Need Help - Access Vlookup

    hi
    I have created two tables containing the SALARY and DEDUCTION . In the SALARY table i created 2 fieldname call 'Montly Salary' and 'Salary Deduction'. For the DEDUCTION table i had 2 fieldname call 'Salary Range' and 'Sum of Deduction'.
    My problem is, i want fieldname 'salary deduction' automaticly do a Vlookup to DEDUCTION table. I try to create but MS Access not recognise the VLookup funtion.

    Please help me on this...Thanking you in advance.

    ryfiz

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    make the deduction box a combo box based on the salary box. After update of the Salary box, requery the deduction box. VLookup is only in spreadsheet programs. databases do that differently.

Posting Permissions

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