Help writing queries (1 Viewer)

[marleyuk]

Hello, i have a database that imports a file, the file is added to a table and then queries are run on it. From here it is exported into a .txt file. The file im importing and processing is about rainfall over a 25 year period. Ill attach some test data to this post as a example of what it looks like.

Can someone help me write the queries as my query writing skills are not what your average person might consider good.

Here they are:

Filter out and ignore idividual spills below a user definable
volume.

This means in each column there may be several spills, the volume of
each spill in each column would need to be calculated and then
spills below a certain level filtered out.

..............


Split and combine cells - 2 short short spills
(a couple of hours each) could occur with a few hours between them
in one tidal cycle and we may need to count them as one spill not
2. The user should be prompted to whether or not they want to add
or spill cells.


................


Which rainfall events spill and the volume for each event. Each event
will have a start time and a finish time so relationships can be found.


Thanks for any help.
Marley.