Search results for query: *

Cheers for the help, to be honest, it's turning out to be a lot trickier than originally planned. There is only one log per incident, each has it's own unique reference number and is updated as and when required on the separate logging system. I receive an excel download on a monthly basis. This...

All data is recorded on a completely separate system. I only have access to the monthly download onto Excel. It is only at this point that I can transfer the data to Access. This is why it is so important that I be able to import and update the data on a monthly basis. HTH

Not sure about this one...are you suggesting a lookup or macro to locate all duplicates before I import the data? As these are calls logged with a helpdesk over a month, I am talking a few thousand lines of data each month.

Thanks for your response, just to clarify the data from month one is made up of open and closed calls. I need to keep the closed data as is, but any calls that are open will have been updated in month two and these I need to overwrite with the month two data and so on each month. Each incident...

Morning all, I am extremely new to Access and have been put on the spot to create a whole new db for a helpdesk and get it all up and running! Ok so far on the normalisation, etc, but am having difficulties as on a monthly basis we download a set of information to an Excel spreadsheet. The...