I need help on this ....

[Steve]

Production data Sheet
_______________
Job no time
1001 60
1001 50
1001 40
1002 30
1003 50
1003 30
1004 10

Price data Sheet
____________
Job no Price
1001-1003 100
1004 200
1005-1007 500

Merge Data (This is what i wanted)
______________________________

Job no time Price
1001 60 $23.08
1001 50 $19.23
1001 40 $15.38
1002 30 $11.54
1003 50 $19.23
1003 30 $11.54
1004 10


I have 5k rows of data. How can i merge production data and price data
together based on the job No

 

[Bob Phillips]

Where does 23.08 etc. come from?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)