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

Reply

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,598

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

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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  
Reply With Quote
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,598

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

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


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

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

Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 4 Post(s)
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  
Reply With Quote
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,598

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

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


It's the year of the enema!
Air is offline  
Reply With Quote

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