cblock1025
Technical User
Ok,
I have a table called transaction contains these fields:
TransactionDate, Amount, type = either S(Service) or P(Payment).
I wanto to sort these out like this in a report:
All my Services on one side and all Payments on the other side:
Date Type Amount Date type Amount
01/01/04 S $ P $
So all payments on one side of the report and all services on the other side. I was trying to do it with two queries and then unite them some how.
Christian, Thanks ahead of time
I have a table called transaction contains these fields:
TransactionDate, Amount, type = either S(Service) or P(Payment).
I wanto to sort these out like this in a report:
All my Services on one side and all Payments on the other side:
Date Type Amount Date type Amount
01/01/04 S $ P $
So all payments on one side of the report and all services on the other side. I was trying to do it with two queries and then unite them some how.
Christian, Thanks ahead of time