L
lcoreilly
Hi All, I have a table in my database that is structured by program ID
(abc123) and reporting period (1-10). Does anyone know how I would
run a query that would pull the most recent data for each program ID?
I need one record for each program, and if there is data for reporting
period 10, I would want that to show, if not -- show 9, etc.
Thanks in advance for any help you can provide.
(abc123) and reporting period (1-10). Does anyone know how I would
run a query that would pull the most recent data for each program ID?
I need one record for each program, and if there is data for reporting
period 10, I would want that to show, if not -- show 9, etc.
Thanks in advance for any help you can provide.