Item count

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Catworks Cat - 24 Jul 2007 14:22 GMT

In my database as each item is counter into inventory it is added as a new
line. When I do a report it shows all the lines of the same item. How do I
just get a quanity total of the item?

Thanks

Cat

Reply to this Message

scubadiver - 24 Jul 2007 15:46 GMT

My line of thinking is to base the report on a totals query.

When you create a query just click on the sigma symbl (looks like an "E")
and decided what grouping and totals you want.

> In my database as each item is counter into inventory it is added as a new
> line. When I do a report it shows all the lines of the same item. How do I
[quoted text clipped - 3 lines]
>
> Cat

Reply to this Message

Miranda - 27 Jul 2007 19:58 GMT

You could use the count formula in your report.

Signature

Miranda

> In my database as each item is counter into inventory it is added as a new
> line. When I do a report it shows all the lines of the same item. How do I
[quoted text clipped - 3 lines]
>
> Cat

Reply to this Message