Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
adding up 1
- Thread starter ryne23
- Start date
-
1
- #2
- Thread starter
- #3
I will be creating a query to hold the calculation. What it is I actually need is a way to start with 0 total. I will have a field on the form to enter the number of items being added to the inventory. I just haven't been able to get it to add to the total in the query without doubling up the total.
OK, am I on the right track here?....
ID NAME AMOUNT
1 hat 5
2 shoes 10
"SELECT Sum(Amount) as Total FROM MyTable;"
The query will return the total amount entered for each record (ie. =15). You can discriminate the item by adding a WHERE clause to the SQL (ie. WHERE Name = 'hat').
What am I missing?
Gary
gwinn7
ID NAME AMOUNT
1 hat 5
2 shoes 10
"SELECT Sum(Amount) as Total FROM MyTable;"
The query will return the total amount entered for each record (ie. =15). You can discriminate the item by adding a WHERE clause to the SQL (ie. WHERE Name = 'hat').
What am I missing?
Gary
gwinn7
- Thread starter
- #5
Your are on the right track. Is the field "hat" in the query only or have you added it to the table. I really don't want a permanten record of the amount added, only the total. That way when i pull this item up again I will be able to add more to the total.
The inventory table has a record referencing "hat". The 5 represents the number of hats in the inventory. In which case, the query I provided is not needed.
However, if you change the total number of "hats" in the table, there will be no record of the change. Are you sure you don't want to track how your inventory was altered and when? This will not help your paper trail if this is the case.
If this is the case, simply choose an unbound field to store the amount of inventory to add or reduce and update the 'Amount' field appropriately depending on the item.
Does this help?
Gary
gwinn7
However, if you change the total number of "hats" in the table, there will be no record of the change. Are you sure you don't want to track how your inventory was altered and when? This will not help your paper trail if this is the case.
If this is the case, simply choose an unbound field to store the amount of inventory to add or reduce and update the 'Amount' field appropriately depending on the item.
Does this help?
Gary
gwinn7
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question