Recent content by dezza9995

Currently the data is all processed using excel. Basically, its a directory of sites which have engineers allocated to them, which change each day. The engineer rota is supplied daily on an Excel spreadsheet. I now have the directory run through Access, which i have working great even using...

I have 2 table currently linked together using a one to many relation. Rather than manually updating the information each day in table 2, i want the same format of data but using a linked excel sheet. This way the information can just be updated elsewhere by the excel sheet. I can't seem to get...

So what i have got so far is the main contract database linked to a separate engineer table. I have an linked excel sheet which contains all the daily engineers. The linked excel data and the engineer table are identicle in format, but how do i make it so the data from the linked excel table is...

The history of the engineer is not a problem, as long as it is the correct engineer showing for that particular day.

I have made an Access database containing contract names and addresses. I need to have each of these contracts linked to another table which shows the allocated engineer for the particular contract. I used a "one 2 many" relationship using a field "LinkID" to do this. Each engineer has a unique...