L
Lasse T
I hope I can explain this with my limited english.
I´m trying to create a stock list. So far I have 3 sum queries. One to
calculate purchased items, one to calculate sold items and one that joins
theese two and calculates stock. Now I can check stock for each item but
only one at the time. If I enter an item number in the query i got stock
value and number of items in stock for that item.
I can not figure out how to get this into a list. Some kind of loop
perheaps?
I tried to make a query with all 3 tables (items, purchased and sold) and
used left join to show all posts. The problem is that i get a row in the
query for each time i sell or purchase the same item number. I understand
that the query has no way of knowing how to deal with multiple posts like
this so I guess that was a wrong approach.
This problems has been bugging me for a while. The database works fine and
are used in a tire and wheel shop and I have an items form that shows number
of items in stock foir each item, using dlookup. Hovewer, the owner (my
brother) would like to be able to print out an inventory list once in a
while to check against his stock.
Any help would be highly appreciated.
Lasse T
---------------
I´m trying to create a stock list. So far I have 3 sum queries. One to
calculate purchased items, one to calculate sold items and one that joins
theese two and calculates stock. Now I can check stock for each item but
only one at the time. If I enter an item number in the query i got stock
value and number of items in stock for that item.
I can not figure out how to get this into a list. Some kind of loop
perheaps?
I tried to make a query with all 3 tables (items, purchased and sold) and
used left join to show all posts. The problem is that i get a row in the
query for each time i sell or purchase the same item number. I understand
that the query has no way of knowing how to deal with multiple posts like
this so I guess that was a wrong approach.
This problems has been bugging me for a while. The database works fine and
are used in a tire and wheel shop and I have an items form that shows number
of items in stock foir each item, using dlookup. Hovewer, the owner (my
brother) would like to be able to print out an inventory list once in a
while to check against his stock.
Any help would be highly appreciated.
Lasse T
---------------