Problem with Update Query

[Michelle]

I have a query that takes cell change data and pushes it back to the main
table.
Main table
IN_INMNUM
IN_NAME
IN_RACE
IN_BLDING
IN_SECTION
IN_CELLDRM
IN_BEDNUM
BSCB - a combination of IN_BLDING, IN_SECTION, IN_CELLDRM & IN_BEDNUM
data example
AB1234
Smith, James
W
H
A
1001
01
H-A-1001-01
Cell Update Data
IN_INMNUM
IN_BLDING
IN_SECTION
IN_CELLDRM
IN_BEDNUM
example of data
AB1234
C
B
1001
01
primary key for both is inmt#

My update query
UPDATE tblCellChange INNER JOIN tblInmtinfo ON tblCellChange.IN_INMNUM =
tblInmtinfo.IN_INMNUM SET tblInmtinfo.IN_BLDING = tblCellChange.IN_BLDING,
tblInmtinfo.IN_SECTION = tblCellChange.IN_SECTION, tblInmtinfo.IN_CELLDRM =
tblCellChange.IN_CELLDRM, tblInmtinfo.IN_BEDNUM = tblCellChange.IN_BEDNUM
WHERE (((tblCellChange.DATE)=Date()));

My issue is I also need the BSCB to update can this be done?

 

[Michelle]

I figure it out....