Hi
Im trying to get rid of data in a simple database that is past its expiry date without losing all the existing data.
Specifically i want to be able to remove rows which are older than today.
Any ideas?
Hi
Im trying to get rid of data in a simple database that is past its expiry date without losing all the existing data.
Specifically i want to be able to remove rows which are older than today.
Any ideas?
Presumably you have a date column. You could apply a filter to this -
Custom, Less than then enter today's date. This will display the old
records. Highlight the visible rows and Edit | Delete Rows, then choose
All from the filter pull-down.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks