where in query (1 Viewer)

[srideout2525]

I have a query where I would like to display the records where payment is greater than 0. In other words, where there is a payment made. I didnt mess with the sql, only the design view.

any help

 

[srideout2525]

Sorry all, i was adding too much. Simply >0 works. I'll come back when I have something a little more difficult