please help with calculation!!!

[saragold]

I need to figure out how to write a calculation that finds a quanity:

first finds all entries for a specific field that are not blank , then pulls out all entires for another field with a specific value.

[LiveOak]

I think what you need is a "Find", not a calculation. Go to find mode, enter the desired value into the other field, create a new find request, , enter an equal sign into the Quantity field, check the "omit" box, and, finally, click "Find" or press the enter key.

-bd

[LiveOak]

From Email:

I would like the totals for each of 3 values in the second field to appear in a final report for my database, so I thought I

could do it with a calcualtion?

----

I think you better backup and give me more detail on what your fields are, what is a records in your database, and what exactly you trying to calculate.

It sound like you need a find operation, a summary field, and a report with a subsummary part.

-bd