Update or Append query

Dick7Access

Dick S
Local time
Today, 15:04
Joined
Jun 9, 2009
Messages
4,325
I want to change a text field to a certain text, but only between certain dates. Do I use Update or Append query? I have tried both, without success.

And is this correct. Between #7/21/2019# And #10/21/2019#
 
Hi. To change something that already exists, you would use UPDATE. To add something new (doesn't exist yet), you would use APPEND.
 
Hi. To change something that already exists, you would use UPDATE. To add something new (doesn't exist yet), you would use APPEND.

I have done this query many times, but for some reason my brain wasn't working. I was putting the [Between #8/21/2019# And #10/21/2019#] on the update line instead of the criteria line.

I hate it when my wife let's me do dumb things:eek:
 
I have done this query many times, but for some reason my brain wasn't working. I was putting the [Between #8/21/2019# And #10/21/2019#] on the update line instead of the criteria line.

I hate it when my wife let's me do dumb things:eek:
Would you like to guess how many times I have done that? Glad to hear you got it sorted out. Cheers!
 
My wife lets me do dumb things all the time - unless cleanup is involved. Then she makes it a point to stop me from making a mess on the (table, floor, counter-top, carpet, upholstery, ...)
 

Users who are viewing this thread

Back
Top Bottom