Go Back  Bike Forums > The Lounge > Foo
Reload this Page >

MS Access help: Sum between points

Foo Off-Topic chit chat with no general subject.

MS Access help: Sum between points

Old 02-04-08, 09:58 PM
  #1  
Air
Destroyer of Wheels
Thread Starter
 
Air's Avatar
 
Join Date: May 2006
Location: Creating some FA-Qs
Posts: 3,520

Bikes: Nishiki Sport, Downtube IXNS, 1950's MMB3 Russian Folding Bike, MTB

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
MS Access help: Sum between points

This is confusing but I'll do my best to esplain. I'm making a bike log that has everything I like to record in it. Been using it since April, neat mostly flat file in Access. Of course I got a dose of confidence and got in over my head

I have two issues I need to resolve but they're sort of related.

The easier one to explain:

I started logging the GPS usage to find out how long the batteries last for real. I have a [Maint] checkbox for any sort of maintenance, a [Bat] checkbox for battery changes (also used for the bike computers), [gps] checkbox, and a [TotalT] field for total time I was out/GPS was on, plus [Miles] and [Date] field and a bunch of others.

In a report I want to wind up with a simple chart that looks something like:

Code:
Battery Changes:
 - Date: 2/2/08; 200 miles; 1020 mins
 - Date: 1/2/08; 50 miles; 750 mins
etc...
So I want the data sorted by date descending. Then I want the sum of the miles and time from present until the time before when [Maint]=-1 AND [Bat]=-1 (Access uses a -1 when you check the box). And then sum of the time and miles when those two conditions are met again at an earlier date.

I'm not sure how the syntax would look - any ideas?
__________________
The Almighty Clyde FAQ || Northeast Index
eTrex Vista References || Road Reference


It's the year of the enema!

Last edited by Air; 02-05-08 at 09:32 AM.
Air is offline  
Old 02-05-08, 03:06 PM
  #2  
Air
Destroyer of Wheels
Thread Starter
 
Air's Avatar
 
Join Date: May 2006
Location: Creating some FA-Qs
Posts: 3,520

Bikes: Nishiki Sport, Downtube IXNS, 1950's MMB3 Russian Folding Bike, MTB

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Anyone?
__________________
The Almighty Clyde FAQ || Northeast Index
eTrex Vista References || Road Reference


It's the year of the enema!
Air is offline  
Old 02-05-08, 05:58 PM
  #3  
jaxgtr
Senior Member
 
jaxgtr's Avatar
 
Join Date: Jul 2006
Location: Jacksonville, FL
Posts: 4,359

Bikes: Trek ALR 6, Trek CrossRip, Trek X-Caliber 8

Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 5 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Air I will PM you
__________________
Brian | 2015 Trek Emonda ALR 6 | 2015 Trek X-Caliber 8 | 2014 Trek CrossRip Comp
Originally Posted by AEO View Post
you should learn to embrace change, and mock it's failings every step of the way.
jaxgtr is offline  
Old 02-05-08, 06:02 PM
  #4  
Air
Destroyer of Wheels
Thread Starter
 
Air's Avatar
 
Join Date: May 2006
Location: Creating some FA-Qs
Posts: 3,520

Bikes: Nishiki Sport, Downtube IXNS, 1950's MMB3 Russian Folding Bike, MTB

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Thanks!!!
__________________
The Almighty Clyde FAQ || Northeast Index
eTrex Vista References || Road Reference


It's the year of the enema!
Air is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.