Search results

If you create a form and make the Record Source a table or a query linking several tables. Then bind each field on the form to a field from your record source then the data is automatically inserted into (or modified) the table(s). You don't need SQL at all if you do it this way. The simplest...

Basically many to many relationships are not a good idea. Try to keep all relationships as one to many creating intermediary tables if necessary. Here each building can have many desks but each desk should only have one building. If it moves from one building to another it should be disconnected...

If you want to add time to a date use DateAdd - for example OutBy = DateAdd("d",4,DateReported) will add 4 days to DateReported giving OutBy or you could use DateAdd("d",ResponseTime,DateReported).