OK ok ok....
So at the moment the code loops through from
BETWEEN txt_date and txt_dateto, adding the rows and filling the data in.
What i need to do though is UPDATE the data if it already exists with that date and that flightsresortid.
My previous attempt looked at performing a query to see if data existed between the dates, and then if it did, deleteing it. then using your code to loop through the whole lot to add it again but with the updated info from the form.
This worked well until i did the delete query between the dates. The reason being is that in some cases, only some records existed, so when i was running it, it would delete 1/1/1, 2/1/1, 3/1/1 etc. but if my BETWEEN DATES was 1/1/1 to 10/1/1 and i only had data up to 5/1/1, then i would get an error.
So how do i do this ?
Cheers
