L
Letty
I have a table/form in which I keep track of office supplies and a
table/form that staff fills out whenever they take office supplies.
I made 2 queries: one gives me the running total of each item as I put them
in storage and another that gives me the running total of each item as they
are used by staff members.
How do I make either a query or report that will
1. List each item
2. For each item, subtract the totals of what a staff members have taken
from the totals of what has been put in storage, so I know how low in supply
each item is.
table/form that staff fills out whenever they take office supplies.
I made 2 queries: one gives me the running total of each item as I put them
in storage and another that gives me the running total of each item as they
are used by staff members.
How do I make either a query or report that will
1. List each item
2. For each item, subtract the totals of what a staff members have taken
from the totals of what has been put in storage, so I know how low in supply
each item is.