Results 1 to 1 of 1
  1. 02-05-2011, 07:21 AM #1
    wrenchman123
    wrenchman123 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Feb 2011
    Posts
    1

    Update Querry

    I have a large table which contains the following fields:
    Part number
    Descritpion
    Cost
    List



    When the supplier sends a new file the prices are all updated and new part numbers are added. Sometimes part numbers change up or suspercede to a new number. When a number changes up, the description field contains "Use #########" ####### being the new number, cost and list price field are then empty.

    I want to create a querry that will find the new part number in the table and update cost and list of the OLD part number with the new pricing.

    Not sure how to being on this one any help would be great.

    Thanks in advance
    Dj
    Last edited by wrenchman123; 02-12-2011 at 11:33 AM. Reason: Does any one have any ideas??????????
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Large SQL Server table linked to Access datasheet is slow to update on first update
    By slevine in forum Access
    Replies: 1
    Last Post: 01-22-2011, 12:23 PM
  2. Update field in table after update on a subform
    By jpkeller55 in forum Queries
    Replies: 3
    Last Post: 09-30-2010, 08:02 PM
  3. Open Querry that looks nice???
    By 95DSM in forum Access
    Replies: 2
    Last Post: 07-11-2010, 11:11 PM
  4. Querry IIf Output Format (Access 2003)
    By Bruce in forum Access
    Replies: 2
    Last Post: 12-03-2009, 06:52 PM
  5. Querry formating
    By Zoroxeus in forum Queries
    Replies: 0
    Last Post: 03-07-2006, 11:00 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums