Update query to exchange 2 fields (2000, 2003)

Topic

New Reply

Hi All,

I have a table with these two fields:

artWidth
artLength

What I need is an update query that swaps artLength and artWidth if artWidth > artLength

Reply | Quote

Replies

Hmm. Tried a bit on my own and came up with:

UPDATE tblArtArtikel SET tblArtArtikel.artLength = [artWidth], tblArtArtikel.artWidth = [artLength]
WHERE (((tblArtArtikel.artLength)<[artWidth]));

Is this OK?

Reply | Quote

Yes, that should work.

Reply | Quote

Yep, thanks.

Reply | Quote