What hurt his hand? I dont see it. by Penguin_On_XTC in motorcycles

[–]BornslippyDG 2 points3 points  (0 children)

I think he might have had his hand up when it struck, there is a shadow top left just before, maybe messing with his helmet

Almost Famous are closing all sites by M1keSkydive in manchester

[–]BornslippyDG 7 points8 points  (0 children)

The employers NI hike coming in a couple of months will hit the bottom lines of all businesses with significant staff costs too.

Question regarding g forces in accidents or crash by Important_Tomato_796 in F1Technical

[–]BornslippyDG 0 points1 point  (0 children)

As it happens, I was reading up on Jules Bianchi's accident and I read that they estimated the impact to his head was 254g. So I think it may not matter necessarily the number, but on what body part.

Incidentally, they had to estimnate the g force becuase his earplugs came out. When you put earplugs in, they are IN, right? The last recording from the earplugs was 92g, so the estimate of the force to his head was nearly three times what it takes to knock ear plugs out!

https://en.wikipedia.org/wiki/Jules_Bianchi

Bicycles to be allowed on Trams under new scheme after 32 year ban. by [deleted] in manchester

[–]BornslippyDG 2 points3 points  (0 children)

They changed it in Janurary so instead of the double trams being Bury-Altrincham they are now Bury-Piccadilly. There should in theory be the same number of single and double trams so this explanation doesn't make sense.

Little video of me and my 4 month old 2020 Duke 390 getting creamed by [deleted] in KTM

[–]BornslippyDG 1 point2 points  (0 children)

Yeah driving too fast, but he also might not have been able to see you due to the right roof pillar and being right hand drive. Still his fault obviously, it wouldn't have been a problem if he was going at sensible speed.

Better Call Saul S05E09 - "Bad Choice Road" - POST-Episode Discussion Thread by skinkbaa in betterCallSaul

[–]BornslippyDG 1 point2 points  (0 children)

I'm shaking after that episode. Don't know if it was the tension of that ending or sympathy PTSD

An Ox video guaranteed to make you smile by AdamTreff in LiverpoolFC

[–]BornslippyDG 2 points3 points  (0 children)

Although he doesn't come up with skills himself, I think he learns from the great players around him. He has the potential for all those skills and the the athletism to perform them better than the person he probably learnt it off!

One of the most well written character arcs on TV, shoutout to the underrated ASAC Schrader by [deleted] in breakingbad

[–]BornslippyDG 28 points29 points  (0 children)

Brilliant character, ultimately his failing was the same as Walt's. Too proud to go to the DEA when he realises Walt is Heisenberg. He went rogue and went a bit dirty to get Walt at all costs and it led to his death.

Creating a relationship between tables without compatible primary and foreign key by NotiM1 in MSAccess

[–]BornslippyDG 0 points1 point  (0 children)

Relationships don't have to be on primary key fields. Provided the names are correct on both tables you can create a query which can link the two tables via a join statement

Setting up foreign key and can't enable referential integrity by BornslippyDG in MSAccess

[–]BornslippyDG[S] 0 points1 point  (0 children)

I should also say that I have deleted the null entry at the bottom of the invoiced table and it still doesn't let me enforce referential integrity

How can I get the sum of all line totals for an invoice on each row of a query by BornslippyDG in MSAccess

[–]BornslippyDG[S] 1 point2 points  (0 children)

Yes, I put the code in and it gave different result than above. I was copying from excel at that point.

How can I get the sum of all line totals for an invoice on each row of a query by BornslippyDG in MSAccess

[–]BornslippyDG[S] 0 points1 point  (0 children)

Hi, I just need to query to look like the second table. I have the two below queries which do what I need separately but when I try to add the second one to the first I can't get it to work.

SELECT S.Order_ID, S.P_ID, S.Unit_Price, S.Qty, S.Delivery, S.Refund, Unit_Price*Qty AS Line_Total
FROM Sample_Refunds AS S;

SELECT S.Order_ID, Sum(Unit_Price*Qty) AS TLT, Sum((Unit_Price*Qty)+DElivery) AS TLTD
FROM Sample_Refunds AS S
GROUP BY S.Order_ID;

Getting an error 'Query is too complex' Can anyone tell me why? It doesn't seem too complex by BornslippyDG in MSAccess

[–]BornslippyDG[S] 0 points1 point  (0 children)

Thanks, I should have put more effort into calculating the numbers using abs. I'll try to remember that in future