Recent content by oxyi

Update: by deleting the extra SDRecord table, it is now running correctly ! thanks For future refrence, is there any way that I can just specific I want SDRecord only and not other with similar name ?

Hi, thanks for the reply. I am looking at the tables now. there indeed has 3 SDRecord tables but they are named differently tho. SDRecord - which is the one I want to work on SDRecord_062607 - I assume this is a backup SDRecordBackup - I assume this is a backup as well. NewSDRecord - not...

Here is the query I wrote to update UPDATE SDRecord SET SDRecord.USE_CD = "820" WHERE (((SDRecord.RM_STD)="CLI"));

Hi thanks for the help ! I tried to do the Query Update function, select the Field I need to update, and put in criteria, and select the field that I need to update to. It seem to be working but after I press run, it came back with a message stating that I am about to update 1858080 rows...

Hi, I am new with access , currently using access 2007. I was given a building record query, and was asked to append a value - RM_TYPE_DESC, and depends on what the value is and assigned another value to this USE_CD field. For example, if the value for RM_TYPE_DESC is CUSTODIAL, then it...