If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Append Queries and how to use them to update tables
So I have this database, and Ive been told here to use an
append query to update my data from my filter table/form to my actual inventory table/form. Im assuming I would then use a delete query to nuke all the data in the filter table/form, as it would no longer be necessary. I would link both of these queries to a button, with the append acting first, then the delete. I get that (i think). Part 2 of my problem is that from the inventory table/form I want to select individual records displayed in my form, and then append/delete those to a shipments table/form. What I dont understand is how to build the statements to make sure that its only copying the records that I want. For instance, I have an inventory with warehouse tag 123, model number XYZ, and serial number 987. I want to make sure it verifies all 3 of these before copying the record from inventory and nuking it out of the inhouse system. After the entire thing goes through its process, I would probably add the statment Update.FormOutgoing and Update.FormInhouseInventory to get them to auto refresh... I imagine its a simple where statement... but Im stumped and need help. Any takers? |
#2
|
|||
|
|||
Append Queries and how to use them to update tables
Eddie;
This worked for me last night. 252813 ACC2000: How to Automatically Subtract a Quantity Ordered from Your Inventory Go to Microsoft.com and search for the above. Andy "Eddie" wrote in message ... So I have this database, and Ive been told here to use an append query to update my data from my filter table/form to my actual inventory table/form. Im assuming I would then use a delete query to nuke all the data in the filter table/form, as it would no longer be necessary. I would link both of these queries to a button, with the append acting first, then the delete. I get that (i think). Part 2 of my problem is that from the inventory table/form I want to select individual records displayed in my form, and then append/delete those to a shipments table/form. What I dont understand is how to build the statements to make sure that its only copying the records that I want. For instance, I have an inventory with warehouse tag 123, model number XYZ, and serial number 987. I want to make sure it verifies all 3 of these before copying the record from inventory and nuking it out of the inhouse system. After the entire thing goes through its process, I would probably add the statment Update.FormOutgoing and Update.FormInhouseInventory to get them to auto refresh... I imagine its a simple where statement... but Im stumped and need help. Any takers? |
Thread Tools | |
Display Modes | |
|
|