Ask Your Question
0

Base Query to Reset/Set a Field [closed]

asked 2013-01-23 00:19:48 +0100

JohnD gravatar image

I have a table that contains text fields. I can make a query to select the desired records with standard query syntax. I am now looking for a way to set those fields to a specific value.

Example: Change a field called Y5 from a value of ABC to XYZ

I can do this manually (and slowly) using a form entry but would like to find a way to do it via a query.

Any suggestions would be appreciated.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 21:05:17.987935

Comments

JohnSUN - Thank you so much - yes that does exactly what I wanted!

JohnD gravatar imageJohnD ( 2013-01-23 22:26:41 +0100 )edit

2 Answers

Sort by » oldest newest most voted
3

answered 2013-01-23 10:07:22 +0100

JohnSUN gravatar image

It makes SQL-command

UPDATE "Test" SET Y5='XYZ' WHERE Y5='ABC'

How to: Change a field called Y5 from a value of ABC to XYZ

edit flag offensive delete link more
0

answered 2013-01-23 22:28:27 +0100

JohnD gravatar image

JohnSUN - Thank you so much - yes that does exactly what I wanted!

I guess I need to go through some SQL tutorials and learn the language and syntax. Previously (a long time ago) used Paradox and as I recall these kinds of commands were mostly built in to the query structure with a relatively simple UI.

Thanks so much for the great visual. That really helps!!

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-01-23 00:19:48 +0100

Seen: 377 times

Last updated: Jan 23 '13