Creating basic queries

[marleyuk]

I need help setting up some basic queries on my database, i dont really know what fields im meant to be querying so help would be great.


Sample data Included in attachment.

In the sample, seconds is the time step, so 5 minutes would be 300 seconds.


Queries i need to create:

Query 1 - Number of spill timesteps >0.001
Query 2 - Total number of timesteps

 

[marleyuk]

Maybe I should explain more..

I need to make a query that shows the number of time steps that are over 0.001. Ive opened the query page and added what i believe to be the relevant fields to the database but im unsure which criteria box i should be putting in the equation. Also im not 100% sure what it actually is, im thinking something like [tblImportTableTest]>0.001.

Ive added my query setup page so you can decide if its correct so far and where the equation should go..

 

[neileg]

Not very clear what you need to do. What is a spill? If [Seconds] is the time step the criterion of >0.001 doesn't really make any sense. What is the field called SJ28803 etc all about?

The first column in your query is wrong. Take it out. What you need in this row is the name of the field, like you have in columns 2 & 3. Access inserts the table name in the next row.

 

[marleyuk]

The first row cant have names because its going to change.. the only 2 fields that will stay constant are Time and Seconds the rest of the fields represent nodes that will change depending on what file is imported. Seconds is timestep. The file im importing is comming from infoworks, a program used to record water spills over time, so depending on the amount of nodes tested, the amount of columns will change. I need to show how many spill timesteps are below 0.001.

Is that any clearer?
Thanks,
Marley.