Query Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here's what i need to do and here's what I've done so far. I have a sql table that includes the following info po number, receive date, product, description, vendor, amount received,price. I also needed to add freight cost, pallet charge, and other charges so a user could fill these values in. The only way i thought of to accomplish this was to write a query with the sql table and the self made table that includes the new fields. I then thing to use a make table table query. WHat I want to happen is when the query is run information will be updated not delted. With a makle table query the original table is delted first. I thought about an append query but that just adds info on doesn't really update old info. Please help.
 
What I'm trying to do is create a user interface for updating cost info that isn't included in our sql db. I link the table into Access. I created a table in access to hold the data field the user will enter. I write a quert to comine the two tables into one. I want this new table to be updated when changes are made with having to delte the table and rerun the make table query.
 
Back
Top