Update or Append query (1 Viewer)

Dick7Access

Dick S
Local time
Today, 10:47
Joined
Jun 9, 2009
Messages
4,197
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#
 

theDBguy

I’m here to help
Staff member
Local time
Today, 07:47
Joined
Oct 29, 2018
Messages
21,358
Hi. To change something that already exists, you would use UPDATE. To add something new (doesn't exist yet), you would use APPEND.
 

Dick7Access

Dick S
Local time
Today, 10:47
Joined
Jun 9, 2009
Messages
4,197
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:
 

theDBguy

I’m here to help
Staff member
Local time
Today, 07:47
Joined
Oct 29, 2018
Messages
21,358
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!
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 09:47
Joined
Feb 28, 2001
Messages
27,003
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

Top Bottom