Hi, I'm a relative newbie so please format answers simply and with as
much explanation as possible.
I have a simple flat inventory database, Each record has a Part Number,
Serial number, Quantity and New/Used (in which the value is either "N"
or "U") fields. And a check box indicating New or used which I added.
Most items in the database are a single item and the quantity is 1 but
some small parts are in lots of items so quantity might contain 15 or
20 and the serial number is then N/A
I have been able to count the total quantity of items in the found set
by using Summary, total of Field "quantity"
What I would also like to do is display in 2 sperate fields Total of
Used and total of New items for the found set. Preferrably by counting
New and Used and summing the Quantity, but I could live with just a way
to count total of "new" and "used" records.
I inherited this database from a former employee who quit with no
notice. He also appears to have taken the Filemaker book with him, so I
don't have access to it.
I've looked through this newsgroup & tried a few of the things
mentioned here, but none worked for me.
Any help will be greatly appreciated.
remove "remove & invalid" to reply via e-mail.