This might be a dumb question, but I am pretty new to Access....
I am trying to write code in Access to take river forecasts which are
delivered as attachments in emails and append the data into an Access
Database. Some forecasts are updated 4 times a day and others are
only updated daily. I am trying to write a code which will only
update the new forecasts and not cause repetitive data from the
forecasts that only change once a day. (Some sort of "Append new data
only" query). I have looked at some of the posts on here but I don't
understand enough about access to fully understand what they are
suggesting.
Each record that is entered into my master table has the following
fields:
Created Timestamp (when the forecast was actually made)
Forecasted Date (the date and time the forecast is for)
Value (the actual value of the forecast)
So the Created Timestamp will change with each new spreadsheet that is
sent out even though the forecast will remain the same. I want to
write code so that the forecast will only be appended when the range
of the forecast changes.
I don't know if that makes sense, but any suggestions are welcome.
Thanks
Anna Warloe