Whats the separator for this query?

[Zaichik123]

Probably two of the easiest questions ever, but how do I combine these two queries?

UPDATE CWT_Room SET CWT_Room.cwfADB_RoomCode = CWT_Room.cwfRoomTypeTemplate;

UPDATE CWT_Room SET CWT_Room.cwfExtRevCde = CWT_Room.cwfRoomTypeTemplate;

I was thinking UPDATE CWT_Room SET CWT_Room.cwfADB_RoomCode = CWT_Room.cwfRoomTypeTemplate AND CWT_Room SET CWT_Room.cwfExtRevCde = CWT_Room.cwfRoomTypeTemplate;

but its asking me for a parameter...

 

[Golom]

Try
[blue][tt]
UPDATE CWT_Room
SET cwfADB_RoomCode = cwfRoomTypeTemplate,
cwfExtRevCde = cwfRoomTypeTemplate
[/tt][/blue]

 

[Zaichik123]

Thanks Golom,

But its then asking me for a parameter - I've not come accross these before - how should I tackle it?

 

[Golom]

Usually that is the result of your having an incorrect field name. Access checks the table source(s) and discovers no field with that name and decides that it must be a user supplied parameter. Check your field names for correct spelling. Could cwfExtRevCde really be cwfExtRevCode for example?