Hello I hope someone can help with this. I need to subtract dates in current record from previous record for the current store.
The key fields in the form are customer, store number and date picked up.
I have used a query to put all records in order of consumer, store number and date picked up and I am using a form to view it. I can use =max([date picked up])-[date picked up] to do the subtraction but I need to only be looking at like store numbers for each max calculation without having to filter. For example if I want to look at all store customer “A” this method does not work because there are many different store number with different last pu dates.
It is a large data base so the simpler this can be made the better. I should be able to tie the max statement to the store number field. I just don’t know how. Also this is access 2003.
Thanks
Steve