time stamp

[lwilt]

What would be the easiest way to create a time stamp for when a query is run without having to create a date field and constantly changing the date each time you run the query?

 

[lwilt]

just having it add the current date at the time it's ran would be great....if it could add the time of day it happens then that's even better

 

[Joe4]

What kind of query is it? A simple Select query, or an action Query that updates records?

If it is a simple Select query, I am afraid that you will probably need to control how the query is run through a form, and have the form run an action Query or some VBA code to update a datestamp field somewhere. See: How do i show the date a report or query was last run? | PC Review

 

[lwilt]

it's just a simple query where I'm adding attention information to a data set before moving to my email platform to upload and since that doesn't time stamp it I would like to do so before it goes up.

 

[Joe4]

When you say "adding information", are you adding new records, or changing/adding information to existing records?
Can you timestamp be placed on individual records?
Also, which version of Access are you using?

You may want to take a look at these links, and see if they would be sufficient to your needs.
https://support.office.com/en-sg/ar...modified-0c46efc5-5b43-4751-b3a8-c246505af66d
https://support.office.com/en-sg/ar...-records-2abe2c7b-7256-4814-aae5-47e4d262e5e9

 

[lwilt]

it would just be adding addition fields to the data already there. its the 2010 version

it looks like I could just set up a macro for it and do it that way