Search results

  1. B

    Identifying timeseries data gaps

    Hi once again, I had posted this in another thread but coupled it with another question but I think its better to separate them out as both seem quite complex (at least for me). I have a very large dataset in the form of timeseries data for different weather station locations. Unfortnately...
  2. B

    Summarising daily rainfall data

    Hi, I apologise again if this is something I should rather being doing in Power Pivot but I thought it might actually be better in Access. I have timeseries data with recordings of rainfall every 5 minutes for multiple locations all in one table. I'm trying to create a query that will sum total...
  3. B

    Finding gaps in a dataset based on timestamps and possibly infilling

    Hi, I'm new to access but working with a relatively large dataset of approx. 1.5 million entries from weather station data. There are however gaps that I need to identify and in an ideal world run an update query to insert rows with the missing timestamps but with all data points set to blank...
  4. B

    Hey :-)

    Hi, My names Matt and I'm new to Access and currently using it to store large amounts of weatherstation data but not without some struggles. I'm a researcher at the ETH in Zurich but currently living in Uganda and look forward to learning more about how Access can be fully used. Nice to meet...
Top Bottom