Update Data, and set field

[adams.bria]

So currently I am having people fill out a form from google docs, and I have that table as a linked table in my db. Here is my problem, I have a column in the google docs spreadsheet that is the number of lab assistants requested. I want to move that number into a field empl_request.num_req AND when that happens set Emply_request.Occ_id to '1'. Then take number of customer service attendants requested, move that to field Empl_request.num_req AND when that happens set Empl_Request.Occ_ID to '2'. And it is only going to do this when the primary keys match. The only PK I can use in the Google Docs table is timestamp, which is a FK in tbl_DC_ID and the PK in tbl_DC_ID is DC_ID. DC_ID is a FK in Empl_Request.

In sum, I am trying to set Occ_ID to a specific number, only when num_req is coming from a specific column. Which simply seems ass-backwards to me.

Here is a quick look at the table structure. I'm thinking I won't be able to do this with a query and would have to use VBA, but I'm not sure where to start. Thanks.

[adams.bria]

Realized I need to use a case select in VBA, thus now I'm in the wrong thread. Going to close and open in new thread, will link when complete.