Hi, I am fairly new to Access/SQL and maybe this is so basic that nobody asks, but I can't find the answer.
I have an Access table setup to collect daily stats from a team. The team wanted to use an Excel spreadsheet for entering their data so I just made a macro that runs on closing of the spreadsheet to push the data into my table. They are only supposed to be entering the data once per day, but I have found that they update the data multiple times per day.
I have a timestamp field that records the date/time of each new entry called acc_timestamp.
Now I am trying to create a query that only shows the last record that is created each day, but I can't seem to find a way to do it. I have tried using DatePart for the day to get unique days, but I am not even getting that right and that doesn't even start to tackle the limiting to the last time of the day.
Any suggestions?
I have an Access table setup to collect daily stats from a team. The team wanted to use an Excel spreadsheet for entering their data so I just made a macro that runs on closing of the spreadsheet to push the data into my table. They are only supposed to be entering the data once per day, but I have found that they update the data multiple times per day.
I have a timestamp field that records the date/time of each new entry called acc_timestamp.
Now I am trying to create a query that only shows the last record that is created each day, but I can't seem to find a way to do it. I have tried using DatePart for the day to get unique days, but I am not even getting that right and that doesn't even start to tackle the limiting to the last time of the day.
Any suggestions?