Update value (2003)

Topic

New Reply

Hi,

I have about 35 different fields with the similar value (such as Y, N) in my database. Now I have to update Y to 1 and N to 0 in all of 35 fields.

So what’s the best way to update it?

Thanks in advance.

Regards,

Reply | Quote

Replies

Why do you want to do this?

Are they all in the same table?

Reply | Quote

Hi,

That’s requirement of another system import specs. I will export it to txt file.

Yes, they all are in the same table.

Thanks,

Reply | Quote

Does the other system link to this system and get the data that way?

Why not just build the query substituting the valu in the query? Or do you have to make a permanent change?

There’s no easy way to do it, well not that i’m aware of anyway.

Reply | Quote

So do I have to use update query and select all 35 fields to update it?

Is there any better way to replace those value on all of 35 fields?

Thanks,

Reply | Quote

You’d need lots of update queries because of the incorrect design of the table. It’s probably easier to open the table in the Access interface and to use Edit | Replace, setting Look in to the table, and Match to Whole field. First replace Y with 1, then replace N with 0.

Reply | Quote

Thanks, Hans.

But I never use the Access interface, can you provide more detail of how to open and edit it? Do I open the table in view?

Thanks again.

Regards,

Reply | Quote

Open the database.
If necessary, activate the Tables section of the Database window.
Double-click the table to open it.

Reply | Quote

How many tables are involved ?

Reply | Quote