Access Update

I require the following database updated: The product table requires a link to the cell table that will allow it to populate the goal field that is in relation to the production table work area field: An example if the work area is CC1 it should populate the goal field once data has been placed into the production form. Note: You will see in the production table the proper goal is not being captured when data is being input from the production form. As data is placed in the production form and should auto update to the production table. Problem: when the query is being generated it is not pulling all data to date. Query: 1: Group production Query: Should return all values to date from the production table [what shift?] group by date clock 2: Production by rate query specific: should return all values placed in the production form daily. Manager will select clock number and date range. expectations is to return all values to date. [What clock?] [What date range] Note: return total average percentage for selected range. Currently using Microsoft Access 7