Thank you for your response.
In my data I would want the minimum date in the list, so for EMP1 that would be 1/1/23 and for EMP2 that would be 18/1/23. Eventually they would fall off the report as they are completed.
I have a database that I can't control the table set up for as it comes from another system.
I have a SQL copy of this database that I write queries & reports from using Access. I have a query which works but I need to filter down further so I end up with just one line entry per person of...
I have a fairly simple working query where it is picking up review dates by open claims, there is a field called DONE. I need to have a count of the "DONE" check box (results are Y or N) and I can't figure out the expression builder for this
Basically, need to count per claim # how many Y and...
Hello,
I am an old access user that hasn't been using for the better part of 25 years.... so much change and frankly so much forgotten!
I am a Canadian and work in healthcare. Just recently been given a SQL version of my database and I am using access to run queries and reports.... somewhat...