Adding Quantity

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

Guest

I need to have a way that i can add and item number and quantity received
that will ADD to the existing quantity of that part number, not creat a new
seperate record. How do I do this from a form or page?

Thanks,

Cat
 
Hi

The simple method would be to create a new table then link this to the part
number in the main table.

Main Table
Part Number
Name
Etc

New Table
Purchase ID
Part Number
Amount ordered
By Who
Etc
Etc

Then create a query to combine the two - you could then have a subform
showing the total orders for any part number showing at anytime you look at
the part. Also would be a good idea for restocking etc etc.
 
create a query using this SQL:

UPDATE
[Your Table Name]
SET
[quantity field] = [quantity field]+[a number]

Then create a button that assigns this query to a querydef and then
set the parameter "a number" to a value and execute it.

Look up querydefs.

Cheers,
Jason Lepack
 
Back
Top