Query to locate a payment method

[dvix]

Hello everyone,

I need your help
I need a receipts report by agent
from date to date
Divided by payment method (cash or checks or credit card or any other payment method).

Thanks in advance ,

[nscheaffer]

You are going to need to provide more details if you hope to get an answer. For instance, what product or software are you working in?

[dvix]

hi,
what do you mean by providing more details?

i need to form a query, that would tell me who is the agent, what type of method he got the payment from,
the tablr rcv3 get me to know only if it comes from credit card, yet i want to know if a customer payed in another method
thank you in advance