Ok, here’s my problem. I need to extract details from a previous record in a query, if the query matches a specific criteria. This result then needs to be subtracted from the next field in the query.
First of all is this possible? – Some how I doubt it
Secondly I realise my explanation may not be up to scratch so I’ll try and give an example.
Select Phase number ---> Select all records with correct phase number ---> IF ‘Staff ID’ appears more then once (including records not in Phase number), take field ‘FTE’ (number) from current record away from last record with matching ‘Staff ID’ (ordered by date)
I am aware that you can compare records in a query but not how my users want. I am also away that this is more then likely going to require several queries, if it’s even possible.
Thanks for the help
Rob
First of all is this possible? – Some how I doubt it
Secondly I realise my explanation may not be up to scratch so I’ll try and give an example.
Select Phase number ---> Select all records with correct phase number ---> IF ‘Staff ID’ appears more then once (including records not in Phase number), take field ‘FTE’ (number) from current record away from last record with matching ‘Staff ID’ (ordered by date)
I am aware that you can compare records in a query but not how my users want. I am also away that this is more then likely going to require several queries, if it’s even possible.
Thanks for the help
Rob