Good Afternoon all;
Is it possible in a query; to show a list more than 25 days old of the creation date?
In my table I have the following:
RecordId - Auto Number
RecordCreationDate - Short Date with the following default set:
ItemNumber - Number Field
ItemDesc - Text Field
ActionDate - Short Date
ActionTaken - Text
What I need to do in my query is show all items over 25 days old of the RecordCreationDate with no action taken against them. is this possible?
Kind Regards
Tor Fey
Is it possible in a query; to show a list more than 25 days old of the creation date?
In my table I have the following:
RecordId - Auto Number
RecordCreationDate - Short Date with the following default set:
Code:
=Date()
ItemDesc - Text Field
ActionDate - Short Date
ActionTaken - Text
What I need to do in my query is show all items over 25 days old of the RecordCreationDate with no action taken against them. is this possible?
Kind Regards
Tor Fey