Hi guys a newby here so be gentle. I am trying to work out how to export data that has two bits of info. A serial number and a status. This I have done with an update query but I now need to put the data bsomewhere then update it every day with the same query. Some of the serial numbers will be the same every day and some will be different. Where and how can I do this. For example serial no 1 is not used today and the same for serial number 2. But tomorrow serial number 1 is used but 2 isn't therefore the list after two days will only include serial number 2 as number 1 being used will remove it from the updated query information. Any help would be greatly appreciated as my head now hurts having had this problem for 2 days now.