Update query

  • Thread starter Thread starter tspies85 via AccessMonster.com
  • Start date Start date
T

tspies85 via AccessMonster.com

Hi,
How do i update my query based on the table? do i need to use update query?.
i've done, but it doesn't work when i enter new record in the table.Is it,
make table query and update query related to each other?
thanks.
 
I can not figure what you are asking. Please restate the problem.
What does your data look like now? Examples please.
What do you want to do to the data?
What do you want it to look like when you finish? Examples please.
 
Hi,
i have one main table which consist of all the data about one item such as
date, specific name,serial number and etc. In my inventory system, once the
item is being bought, the details about the item will be deleted in the main
form.The deleted item will be sent to a table called deleteItem ( which i
done it using make table and delete query). The problem is, when the latest
data being entered, the deleteItem doesn't automatically update the data. So,
i tried to use update query.But still, the data doesn't being updated.I'm
quite new in this area of programming.I can't really see the function of
these action quries...help.thanks..
 
Hi,
i have one main table which consist of all the data about one item such as
date, specific name,serial number and etc. In my inventory system, once the
item is being bought, the details about the item will be deleted in the main
form.The deleted item will be sent to a table called deleteItem ( which i
done it using make table and delete query). The problem is, when the latest
data being entered, the deleteItem doesn't automatically update the data. So,
i tried to use update query.But still, the data doesn't being updated.I'm
quite new in this area of programming.I can't really see the function of
these action quries...help.thanks..
Click to expand...

I'm not sure that either a MakeTable nor an Update query are
appropriate here. My first choice would be to add a yes/no field Sold
to the table; set it to True when the item is sold, and base your
inventory form on a query selecting records where it is False (and
your form displaying sales on a query where it is True).

If you really want two tables, then you can use an Append query to
append the record to the deleteItem table, followed by a Delete query
to delete it from the inventory table.

One way of interpreting your first sentence is that you have one table
per item. If so that's WRONG...!

John W. Vinson[MVP]
 
Hi John,

thank you.but..i would like to know, if i dicided to have two table, ( just
like what your suggest), does delete query will always update it's data
everytime new record is being entered in inventory table?
 
Hi John,

thank you.but..i would like to know, if i dicided to have two table, ( just
like what your suggest), does delete query will always update it's data
everytime new record is being entered in inventory table?
Click to expand...

I'm sorry, I do not understand the question. A Delete query deletes
records from a table. It doesn't update ANYTHING - it deletes records;
and a delete query will not be automagically executed when you enter a
new record in an inventory table.

Please explain your table structures, and post any code that you now
have; and explain what you are trying to accomplish.

John W. Vinson[MVP]
 
Back
Top