Is there a way to query all records that have been changed recently

[NaomiC]

Hi All,

I was wondering if there is a way to query all records in a table that have had changes made recently or since 1/1/15?

Prior to using access, in excel I would move (cut and paste) an entire row from my "active" worksheet to a "scheduled" or "not scheduled" worksheet. Each quarter I would add a new scheduled/not scheduled sheet. My Scheduled sheet had a date column that I could sort by and easily find any appointments that were scheduled in any given quarter. Since the not scheduled records are not scheduled I did not have a date to search for, hence I created a new sheet each quarter. Needles to say it was very time consuming and left a lot of room for error so when I discovered access I moved all my data over prior to the new year.

My Form has the date/time for the appointment so I was able to query all the Scheduled records since 1/1/15 but I completely forgot to add a column for the date the request was cancelled. I know how I can amend my form/table so I can track the Not Scheduled by adding a date now, but is there any way to find the records I have "not scheduled" as of 1/1/15.

Please let me know if this makes sense or if you need any more information. Thanks for any suggestions.

[June7]

You want any records where appointment date is less than 1/1/15?

[NaomiC]

No. If they were not scheduled there would not be a date at all. I am looking for any record I may have updated to a one of my not scheduled statuses. For example, if a person was scheduled I enter the date of the appointment. If they are not scheduled I cancel the request and use a status of: Cancelled, Expired, Withdrew, Declined or 111. I am looking for a way to find the records where i updated this status after 1/1/15, but I did not enter a date of when I did that

Hindsight = Seeing you kick yourself in the ass!

[June7]

No date means no data to filter by. Access does not keep history of when records are edited. That's why some developers construct an 'audit log' feature in db - to document what and when and who edited.

[NaomiC]

That is what I was afraid of Thanks for checking. Do you have any more information about audit logs that I can take a look at?

[June7]

Here is one http://allenbrowne.com/AppAudit.html

There are many variations to be found on web. Search the forum as well.

Might find this of interest http://www.fmsinc.com/MicrosoftAcces...tory/Index.asp

[NaomiC]

Thank you!