Search results

I'm stop and go every day =\

How many miles until your brakes usually wear out? Also, do you guys have any guides for maintained on a car. Something I can keep track of to make sure my car is maintained? For example: Change oil 3000 miles, New tires 30,000 ... just a rough estimate of when you should replace certain...

LOL, for some reason I veered off of spelling it correctly. I started out spelling it correctly in the first couple posts. I think it is cause I'm truly ready for this weekend BREAK, 1 hr 15 left ... whew.

well, if I break really slow say 30 ft before a stop light my breaks usually don't tick. But if I'm maybe 10 miles away and break somewhat late (I don't have a heavy foot on the break) that's when the tick noise comes. I usually need to turn down my radio to hear, but sometimes if a break too...

yeh i'll just go in and get it checked. I'm still under warranty for a good while so hopefully this won't cost anything. thanks dudes.

but they cost money =*(

Yeah this is foreign language to me. So is there anything in particular I should check, ie. abs? Is there anything I can do to get this to stop because it's annoying and it makes me really paranoid while driving...lol

I don't know too much about cars but I just want to know if there is a problem with my brakes. Every time I brake my brakes make a tick noise. My car is relativley new (10k miles). Any clue why it does this? I'm pretty sure my brakes aren't old, maybe they need grease on them.

dcount("Eq_nr","tblCars, everything?) dcount("car_nr","tblUnits, everything?) what would I use for criteria?

I've searched on google for count distinct help but I had no luck. I'm counting 2 different columns and when the query is run the counts in both columns appear exactly the same. Also, I need a SUM distinct (if possible) to sum only where it is being counted in 'CountOfCar_Nr'. Here is my SQL...

Thanks that would be great!!

So I guess you're suggesting using VBA. I know how to do certain VBA things in Access but not so much in XL. Do you by chance have an example of what I need?

One more little problem. I tried playing around with it for 30 min and I can't figure out why it isn't giving me the Average of "Sum of Field1" of each train. Any clue why?

ooops yeah I over looked that somehow. Thanks a ton shades!

oh you did it in formulas huh?

shit how did you do that

well E6/E5 sorry for flipping it around.

Attached. Right under Sum of CountOfeqinit Sum of SumOfLength would it be possible to add a row that has them divided?

If I have two fields for my data that are both SUM. Lets say SUM of cars and SUM of road. Is there any way that I can divide these for every record within the pivot table? So I want to know SUM of cars/SUM of road and have this populate maybe below each instance of the sums. If this is...

Anyone know the answer? I'm testing something out but I'm using another querying tool to get the data which is greater than 65k (excels limit), so I can't import the data I have to manually copy/paste.