Need a query that gives a correct selling price

[Marin]

Hello everyone,



I have 4 tbls looking like this:

Employee .... Price.....Sale...... Amount

eID ........... pID ......sID........ aID
eName .......eID...... sDate .....sID
................pPrice .................eID
................pDate .................aQuantity



What I need is query that gives a correct selling price (pPrice) depending on selling date (sDate), so I need to compare pDate and sDate to get right pPrice.

Hope you can help me,
Thx

[orange]

You haven't told us anything about you tables and relationships, so a reader can only guess what you may have.

see POST #8 at
https://www.accessforums.net/access/...ble-31461.html

[Marin]

Sry, Let's try like this:
You can see Tables with relationships in the attachment 1 And SELECT query in the table below.


On 5th January (sDate), John worked 10h (aQuantity) with the price of 15$/h (pPrice) formed on 1st.Jan.2013.
And again, on the second row, on the same date (5th Jan) we can see John worked for the price of 17$/hr formed on 15. Feb, far after his day work.
What i want is to exclude records like this.