Quick query question...

[steverbs]

Hi all.

Quick question for you (I should actually be able to do this, but my brain seems to have left me here). I have two tables; Bookings and RoomTypeLookup. There are two fields in each table that I am interested in; RoomType and Description. These are both, basically the same. For example, in a single record, if the value in RoomType is 'Single En Suite', the value in Description will be 'Single' and so on.

I have only just created the Description field in the Bookings table and now I need to populate it with the appropriate data based on what is in its RoomType field. All of the necessary data is in the RoomTypeLookup table, where both fields are populated. How do I design this query?

Any help here is greatly appreciated.

Regards.

Stephen.

 

[steverbs]

OK. Got it sorted now (my brain has returned). The trouble I was having was with the query analyzer putting quotes around the field name that I was entering into the 'Update To' field. All I had to do was enter square brackets and the table name ([RoomTypeLookup].[Description]).