Any question answered...

percentages are stored in Excel as floats from 0 to 1 and you are storing as integer in Access, so they are being coerced by rounding down to 0 or up to 1?

What format have you got it set as? It sounds like it's formatted as integer/whole number. You probably want decimal/double.

(Admittedly I'd also consider whether Access is the tool that I wanted to use.)

Cheers.

I've managed to find the field properties.

Admittedly I'd also consider whether Access is the tool that I wanted to use.

Well my experience is limited to MS Office and copying and pasting guides on Ubuntu into Terminal, so I'm not sure what else to use.

Essentially we've been using xls for data, and some template stuff in Word for creating ToBs. Now I've got Access as part of 365 I thought it would be a good way of managing the data with some of our sales agents and using it to create standard ToB quickly.

If there's another free simpletons option. I'm open to suggestions.

My LBS is helping me sell one of my bikes due to a move, and they said that fixed gear bikes aren’t really ‘hip’ any more. What are the cool bikes these days? Minivelo? Dad bike? Steel racers? Any ideas?

HipsterHybrids

Saying it don’t make it true, sadly

they said that fixed gear bikes aren’t really ‘hip’ any more

ha

..by which I mean gravel bikes

Tan sidewalls natch

Is anyone on here based in Southampton? I’m trying to buy a frame from a guy who won’t post and I can’t get to him for a while... can anyone help? 🤷‍♂️😬

Isn’t @Acliff based down that way?

I picked up a wheel with a SON hub (SON28 Classic (K179)- drum-shaped, not spherical) for sod all recently, but it's in a bad way. Extremely difficult to turn about the axle so I'm thinking there's some rust/shit in there.

What do? Is it all possible to open these (even as a science project), or is it an SJS / Schmidt job?

What bike stuff typically uses a Torx T15?

Torx T15

Not much. T25 seems more common. Some esoteric brake fittings?

Basically there's one in this toolkit I'm taking but I can't think of anything that uses it so I want to leave it behind. But it'll be middle of the night in Serbia when X breaks and needs a T15...

Never come across it on a bike of mine before. Just T25 for my silly Zipp stem

T25 is on everything. T10 is on Garmin mounts. T15 maybe some disc brakes or something (nothing I can see on my bike anyway)?

I bought two pairs of shoes online priced £59.99 each, £119.98 sub-total, then used a 10% discount code bringing it to £107.98 total with free postage.

I returned one of pair the shoes and the company refunded me exactly half of £107.98 (£53.99).

This doesn't seem correct, as it means my 10% code is now only 5%? Unless I am missing something here. I was expecting the refund to be £57.99 (£53.99+£4).

EDIT - I'm an idiot.

No, that seems exactly right. 10% off 59.99 is £6 off, so 53.99, which is what you get back, so a refund of 53.99.

Where are you getting the £4 from? If you bought two pairs and return one, it kind of stands to reason they refund half of what you paid...

If you'd bought an inner tube for £5 and shoes for £45, with 10% discount, then returned the shoes, would you expect to get the inner tube for free?

nothing I can see on my bike

If you've checked properly, you can leave the T15 at home. It's not a common size for machine screws, the usual series is T10 for M3, T20 for M4, T25 for M5 and T30 for M6, but you will come across it if you have to dismantle things like power tools and kitchen appliances as it is used on some sizes of Plastite screws.

Yeah, I have no idea where I got the £4 from now. Looking at it again I don't what I was thinking.

Might have to check what size the adjuster is on the Avid cable pull disc brakes I have, BB7 or BB5 or something. They use a torx of around that size.

Edit: apparently t25, but some bleeds and rotor bolts have been reportedly smaller.

Maybe I'll leave it in the kit for when I need to scrounge some spare parts out of hotel equipment...

I have Shimano hydro brakes. No T15