Search results

Here a small subset...

If I initially run this query I get an error stating 'Duplicate output alias Expr1'. I if modify the code so that the second Expr1 is Expr7 I get errors in the database SELECT min_weather.[station name] AS Expr1, min_weather.date AS Expr2, min_weather.year AS Expr3, min_weather.month AS Expr4...

Thank you very much for your detailed answers, especially @arnelgp I think maybe I did not explain myself clearly enough so apologies for that. When there is a gap in the recording of data the gap does not appear in the timeseries but only as a '-9999' in the parameter column. Initially the...

@CJ_London I was checking a specific period in May 2020 as a reference and you can see in post #7 and post #9 both have Kibale 25/05/2020 but neither have the data for the 01/05/2020 which you can see in the raw data @arnelgp You my friend are an absolute legend! If I want to increase the...

Changing to 'LEFT JOIN' gives the same data: SELECT Query1.location, Query1.Date, Query1.SumOfprecip FROM Query1 LEFT JOIN Query2 ON (Query1.location = Query2.location) AND (Query1.Date = Query2.Date) WHERE ((([Query1].[Expr1]/([Query1].[Expr1]+[Query2].[Expr1]))>0.5));

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...

Thank you all for your responses and I will try them one buy one and see how it goes. Like I said I'm just starting out with SQL so you will have to forgive the many stupid questions. I'm trying to complete youtube tutorials but still its a slow process. @arnelgp I think the first two queries...

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...

Sadly I already tried this and if I round only to 6 decimal places I don't get complete matches between the two time series. If I round to 5 decimal places then I get complete matches, however it moves the timestamp out of a five minute sync :-( This is rounded to five: If I only round to 6...

Sorry I've tried ten times to upload either a zip folder, a database or an excel sheet and it just times out. Will try again tomorrow

The analysis will probably be done in R and we are just using Access as a repository for all the data as its too much for Excel to handle. The data will eventually be converted into .csv format so it can analysed on different platforms and climate models. I tried rounding up but it did indeed...

Many thanks for the replies and apologies for crossthreading. My supervisor who will be analysing the data insists this is the format he requires for his analysis and didn't go much further into detail thus my request on how to do this still stands. I have subsequently tried using a MATCH...

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...

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...