Search results

I'm trying to update one table with three fields from another(MTI Number, Error Code, Site). Both tables have the same field names and the common link between tables is via a field called MCR I've put them both in a query - converted to an update query and set the update field on the query to...

I have a query looking at a table looking at several fields. Two of these fields are [Designer] and [Start Date]. Because I want to be able to calculate the length of time a designer takes on a particular job I need the start date to be fixed. Calculations can then be based on that date. However...