Filtering Fields???????

[jbc4321]

Hello all, I am new to this forum along with being fairly new with working in Access. The report I have is generated from a query that I created, each record has fields called status checks (up to 22). I need the report to only display the 5 latest updated status check fields for each record in the report. What is the best way to go about this

 

[ColinEssex]

If you have a query with 22 different status fields, it sounds as if your database is not built correctly. You should have just one status field.

Col

 

[jbc4321]

I know it sounds like that, but its not, anyone have a useable suggestion

 

[usermj]

Only display the 5 latest updated fields..

I wonder whether you need to create a new table column/field to track the time when users made changes on the database. Afterwards, you can ascend the stack column and use for loop to read the last 5 records.

Just a thought, hope it can work.