Concatenate 2 columns in one

[playas]

Hello,



I have 2 tables.

1. Receipts (with 3 columns):
Date - Store - Received
(date/time) (text) (curency)

2. pay (with 3 columns)
Date - Provider - Paid
(date/time) (text) (curency)

I need a table who joins Store/Provider in the same column and Received/Paid in the same column.
the table result will be like:
Date (date/time)
Explanation (store/provider): (text)
Flux (received/paid): (curency)
where store = received and provider = paid
I know this is not concatenate, but I don't know what function is. union?
Thanks

[orange]

You need to structure your tables to match your requirements, and at this point it appears there is a lot you haven't told us.
What is a Store? How does store differ from Provider? How does Receipt fit-- is it connected with a Payment - wouldn't a Payment be made against a Purchase or Order? Please help us by providing a little more info to pull these things together. Also, Date is a reserved word in Access.

[playas]

SELECT Data,A,B,"Incasari" AS [Status]
FROM [1 Incasari];
UNION ALL SELECT Data,A,B,"Plati"
FROM [1 Plati]
ORDER BY Data, A;

I renamed Provider and Store to A and Received and Paid to B
Incasari = Received
Plati = Paid