global changes

[Guest]

I did a query to get all records for a single person in our database. I now
need to change each group field from "DO" to "DirOff"...how do I do this so I
don't have to change each line?

 

[Tom Ellison]

Dear Ed:

It is very difficult to read your query, as you did not post it. Is DirOff
a column name or a table name or what?

I recommend you post the SQL so we can read it.

Tom Ellison

 

[Guest]

I guess I was not very clear as to what I was needing. Sorry!

I have a field in my table called "AllExpenses2006.Group"
Every record in my Finance database that is for something purchased by John
that has a blank "AllExpenses2006.Group" field, I want to be globally place
"DO" in the field, otherwise I have to do 762 records by hand...and that just
for this person, I need to do this for each of our people.

I made the following query to show all records where John Young purchased
something where the "AllExpenses2006.Group" field is blank....we place the
name in the item field (why, I don't know, I inherited this stupid db).

SELECT AllExpenses2006.Item, AllExpenses2006.Group
FROM AllExpenses2006
WHERE (((AllExpenses2006.Item) Like "*Young*") AND ((AllExpenses2006.Group)
Is Null));

Now I need to know how to globally fill in the "AllExpenses2006.Group" field
in query.

 

[Tom Ellison]

Dear Ed:

Open the query you show in Deisgn View and change it to an update query.
Place "DO" in the Update To row under the Group column.

Tom Ellison

 

[Guest]

Yes, how do I do that?

Dear Ed:

Open the query you show in Deisgn View and change it to an update query.
Place "DO" in the Update To row under the Group column.

Tom Ellison

 

[Tom Ellison]

Dear Ed:

I'll assume you can open the query in Design View. Right click inside the
gray area to the top of the window and choose Query Type then Update Query.
The query will now appear with a new row "Update To". In this row under the
column labeled "Group" put "DO".

You should do this in a copy of the database, not the master. Don't destroy
all your data with a simple error while testing and experimenting.

Tom Ellison