Recent content by WardC

Hi Gemma, I am not sure that I am following your post. If you are commenting on the challenges of choosing to use the Excel spreadsheet as the input device, I agree there are challenges and I am working those out. I am not sure what problem you are referring to that would be resolved with...

Because of the way the data is collected it is static, it is not being edited. There is a new record created each time that they change the workbook. This is why I need the query to limit the records to the last by time of day for each unique day. Once I am able to get past this hurdle I...

Thanks HiTech, I thought of this, but when I looked into it further I found that the team is refining their data through the day and that the last update of the day is most accurate. Rather than limiting their ability to send me data I would rather just ignore the data that I don't need.

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...