Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-21-2019, 12:34 PM   #1
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,497
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Update or Append query

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#

Dick7Access is offline   Reply With Quote
Old 10-21-2019, 12:37 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,505
Thanks: 58
Thanked 1,420 Times in 1,401 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Update or Append query

Hi. To change something that already exists, you would use UPDATE. To add something new (doesn't exist yet), you would use APPEND.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Dick7Access (10-21-2019)
Old 10-21-2019, 12:55 PM   #3
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,271
Thanks: 115
Thanked 3,081 Times in 2,799 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Update or Append query

Quote:
Originally Posted by Dick7Access View Post
And is this correct. Between #7/21/2019# And #10/21/2019#
Yes it is correct

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Dick7Access (10-21-2019)
Old 10-21-2019, 01:32 PM   #4
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,497
Thanks: 608
Thanked 41 Times in 39 Posts
Dick7Access is on a distinguished road
Re: Update or Append query

Quote:
Originally Posted by theDBguy View Post
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
Dick7Access is offline   Reply With Quote
Old 10-21-2019, 01:37 PM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,505
Thanks: 58
Thanked 1,420 Times in 1,401 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Update or Append query

Quote:
Originally Posted by Dick7Access View Post
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
Would you like to guess how many times I have done that? Glad to hear you got it sorted out. Cheers!
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 10-21-2019, 07:49 PM   #6
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,713
Thanks: 93
Thanked 1,709 Times in 1,582 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Update or Append query

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, ...)

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Run Append Query after update urobee Queries 9 08-29-2019 02:24 AM
Update or Append Query ramez75 Queries 11 11-25-2014 05:58 AM
Update/Append Query trish Queries 11 05-09-2012 11:26 PM
Update Append Query kabir_hussein Queries 15 12-11-2003 01:54 AM
Append/Update Query alexi Queries 1 06-17-2003 06:41 PM




All times are GMT -8. The time now is 11:25 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World