Can you help?
I need to create a query based on a cost price which may vary each year (e.g. Cost Price for Year1,2,3,4,5 etc all different?)
I have created the Query which works fine - for Year 1 - but now need to "expand" for Year 2,3,4,5 etc
I have a Date field within the same table / form to "dictate" which cost to insert?
(Basically if cost in Year 1 = £1.00 & Year 2 = £2.00 etc - i need the Date field in the table / form to dictate the "correct" cost for that year?