G
Guest
If I wanted to make a append query to append a record and the time it was
entered in a append query how would I do it?
When I create a query that appends [FirstName] to [First] and Time() to
[Time Entered] ....all the appended records in the [Time Entered] field are
the same time/value. I also made a Function that generates a random number
in time format and yet all the records are the same number. Does the query
run that function once and then uses that value till the end of the query?
If so how do I make the query run the function over again till the last
record has been added or updated?
entered in a append query how would I do it?
When I create a query that appends [FirstName] to [First] and Time() to
[Time Entered] ....all the appended records in the [Time Entered] field are
the same time/value. I also made a Function that generates a random number
in time format and yet all the records are the same number. Does the query
run that function once and then uses that value till the end of the query?
If so how do I make the query run the function over again till the last
record has been added or updated?