Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2006
    Posts
    213

    Unanswered: Sql Access query

    Hello,

    I have a database and i would like to run the following queries:

    1. Number of hours spill (depends on the output timestep)
    If the timestep is an hour then the total number hours spill is the same as the timestep, but if the short or longer it needs to be factored.

    2. Number of discrete spills?
    A discrete spill is when the spill stops and starts again later in the column.

    3. Total spill volume (only of timesteps where spill rate is >0.001)
    A total of spills > 0.001. Again is this considered per node or for all nodes in a timestep

    4. Peak spill rate in litres per second.
    Per node

    The problem is i need to do them in SQL and im not very good at it. If anyone who knows SQL can offer some support id greatly appriciate it. If you can post the code with me needing to simply replace terms it would probabally save me hours of trial and error and kicks to my computer case.

    Thanks,
    Marley.

  2. #2
    Join Date
    Feb 2006
    Posts
    213

    damn it

    Bump. Bump. Bump.
    Last edited by marleyuk; 02-23-06 at 09:07.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    It was only an hour before you bumped, ease up there eugene.

    The query you write is going to depend on your table structure. So, what is your table structure?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Teddy
    So, what is your table structure?
    Sample db

    Not normalised - I didn't fancy that particular trauma

    I'm pooped
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by pootle flump
    I'm pooped
    Well after that marathon session with Marley I would hope so ... I was starting to think that you might start dating ... Go rest that flump for a while ... ;D
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Feb 2006
    Posts
    213
    Ha, that was a bit of a quest. And the bump was actually because i posted in here instead of the other topic, but i couldnt see a delete button so i thought id bump it .

    You can get the database here, a few posts down under pootles name :

    http://www.dbforums.com/showthread.php?t=1212896&page=3

    Thanks boys and girls.

  7. #7
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by marleyuk
    Thanks boys and girls.
    I think I like this guy...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  8. #8
    Join Date
    Feb 2006
    Posts
    213

    happy times at marl mont high

    Quote Originally Posted by Teddy
    ease up there eugene
    To be honest i was quite impressed with the above comment.

  9. #9
    Join Date
    Feb 2006
    Posts
    213
    noone offer any help??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •