Meant to say for each item number too ie a count of maintenance events per month per item but only one of the same JobDates not all the JobDates that are equal.

watch the folloing video  
DMax

Thanks Sami but its not really the answer I'm trying to find.

If I have two records both with the same item ID and the same job date but with a different time stamp or entry id I want to end up with just one record ie the last one entered with that Jobdate but I also want all the previous jobdates for that same itemID as long as the jobdates are all unique for that item. ie I can't count two jobs where the JobDates are the same. ie one JobDate per item but must be the last one entered.

Hope that makes sense

ie -- The last one of the duplicate JobDates

The video about Last & First shows to use Max and min instead and gets somewhere near the outcome but I'm having difficulty translating it to solve my problem.

I got it -- and it was fairly simple in the end. Just max'ed the time stamp and then included the itemID and the JobDone date.

Note to self
What I need to remember about queries is that any field you ask it to include must be shown so hence I get every JobDate and every ItemID but only the Max time stamp for each.

  Hope this helps anyone else with this problem -- it solves more than one problem for me as I can now base other queries on this principle to extract other data I need.

Stanley what you have gone through is the best way to learn.

Yes Sami -- my take away from it was that the number of fields you add to any query changes the number of results you get.
  I had other fields I shouldn't have added so they had to be shown in the results so my Max on the aggregate query wasn't giving me the expected results ie it would show other duplicate dates because it needed to show the other fields that were different from the fields on the duplicate date fields hence I got the duplicate dates as well. Cutting those fields out of the query was the answer.
   I twigged it when Richard in his Last & First video mentioned the Max aggregate wouldn't work with all the fields in so he did it with only one field and added the others with a new query.

  Mine was a bit different and I needed to add some other fields that would be the same ie the JobDone date field and the ItemID field otherwise I just got the very last time stamp of the history table. Now I get the very last time stamp of that item and the last JobDate of the item