Sorry if this question has been posted, but I can't find the answer.

 

I have a summary report showing a list of vendors, and the amount paid for a defined period of time. We have 2 fields in this report "Vendor" & "Purchased" (summary field) in the report. We didn't purchased anything from some of the vendors, but they still show in the report. I would to only show vendors that have an amount in the "Purchased" field.

 

Thank you.

It sounds like you should start by finding records whose date is within the report's date range AND whose amount is not empty or 0.

OK, and how do I do that?

Enter Find Mode[]
Set Field [ YourTable::Purchased; "> 0" ]
Perform Find []

This will find records where the Purchased field contains an amount greater than zero. You didn't tell us anything regarding the data range, so I can't suggest anything there. See:

http://www.filemaker.com/help/13/fmp/en/html/find_sort.5.8.html#1028153