Great thank you for your prompt reply
I had both tables in the query already and had the link between employee names I just wasnt sure how to bring the criteria together to bring the correct band through
I have got it all working now based off of your advice
Hi pretty new to access but slowly getting my head around it
I have an issue where I have two separate tables, one of these has line by line timesheet expenditure data for staff, the second table has the staff listed out with all their positions in the company, the band they were in for the...