First, thanks to everyone on this forum and all their great ideas that have helped a lot!!!
And now, the lastest problem –
There is an audit table which tracks record changes every time a record is saved. The table saves the field name that was change, the datetime, new value, old value.
After using the max date filter technique and the fold technique together, I get the last value (day, week, year, whatever I need) and it looks great in a list report… BUT
It doesn’t chart! The chart picks up all the data behind the fold and instead of getting a count of 20 changes for a day-- the charts says 1 1 1 1 1 1 1
Is there a work around for this?
ljkidd9 (BOB member since 2004-06-15)