Nice people thread part 7 - a thread in its prime

PasturesNew

I spent an hour trying to get Asda and Argos pages to load for "cheapest saucepans" so I could see the prices of their cheapos.... and was still unsuccessful as my connection's so dire. So I went out anyway and into Lidl for some goodies (cheesecakes and crumpets). Then weather turned vile so I came back and had 2 crumpets for lunch.... and have just spent a total of 40 minutes trying to get here, to post something/this.... I get disconnected, pages don't load, they're so slow loading they never finish ..... can't wait to join the 19th century and get a fixed BB .... 10 days to go.....

GDB2222

michaels wrote: »

Another in the slept badly felling miserable club - a lot of night time coughers in the house at the moment although luckily not me.

Still it is good to have PN back from her travels safely (I know know I am on a promise PN but life has been so hectic plus I knew you were away).

Does anyone else feel cheated over the length of the xmas break - when it started it seemed like ages but with the first 3 days spent rushing round madly getting ready, the next 2 spent doing and the one after spent clearing up it somehow turned in to a 3 day break and yesterday I fitted in a trip to the dentist that was about a year overdue so now it is just a normal weekend (with the normal weekend chores to do) and back to work on Monday with a lot to do in January and no relief in sight

GDB I will email you details of my builder, they are not brilliant (unless you are their only job or are looking for a new roof) but they will give you a reasonable quote which may be useful for negotiation and would offer me a 5% introduction fee which I would pass straight back to you as a NP.

Sorry about the coughing, and best wishes for a speedy recovering for Mrs Michael and the Michaelettes.

I will be grateful for the builders (and the 5%!). I thought you were keener on them originally, though? Have they faded on you?

I'm fortunate that we will be on holiday until Wednesday/Thursday.

Spirit_2

GDB2222 wrote: »

If you are familiar with Excel, I wouldn't faff around with Access.

To de-duplicate in Excel is easy using a macro.

Or even simpler, just sort the data into alpha order and delete the duplicate rows by eye. If you are only talking about 100-ish, that will take you far less time than learning how to automate it.

.

We can all add our own little quirks in 'how to do'.

To get rid o duplicates I would make a pivot table based on counting a primary field. Filter for the counts of 2 or more. Double click to expand the data in a table again.Then delete duplicates.

Or being realistic. Ask one of the analysts in my team to let me have it.

Spirit_2

sparrer wrote: »

I've just come across this thread,

Have enjoyed reading the posts and will pop back again to see if I've been exiled to Coventry, or considered a fungi so I can stay

Step away now whilst you still have a life.

Enter, only if you are prepared to care sincerely for pixels, other peoples boilers, their old people, careers, housing, dogs, passports,student offspring, ailments and cute children.

You have been warned. Welcome, but it is on your own head if you never have enough time for real life again..

LydiaJ

Welcome sparrer. Always nice to have a new NP. My sole claim to a connection with Hertfordshire is that my brother lived there for a few years and I stayed with him there for a week once, and a few weekends. In fact, my only "typical NP" thing is that I'm a scientist. Do you have connections to science, sparrer, or to Judaism? I don't manage much on the Jewish bit either, although my RL name is Jewish (well, it occurs in the Old Testament, anyway) and I did once accompany a school trip to a synagogue when they needed an extra teacher and I was free.

You say you're new to the Debate board - which boards do you usually hang out on? Are there any you particularly recommend or regard as "home"? I'm a teacher (actually I imagine you already guessed that), and so I've had more time on my hands than usual recently (especially while in bed with the cold I've just got over) and I've been venturing out into parts of the forum where I don't go very often. Of course I've known all along that the NPT is a haven of tranquility amidst the frequent lapses into petty bickering of the rest of the Debate board (although there is also plenty of thoughtful and well informed economics, sparrer, so don't be put off reading threads if they look interesting), but I had no idea how brutal some of the stuff on the relationships and families board is. Lots of supportive discussion, of course, but some of it, well! :eek: The ad hominem attacks on the debate board are tame by comparison. I posted one comment (about adult children of elderly parents becoming less capable of living independently) and then read a few more threads and decided that board's not for me.

Doozer, I'm afraid I know nothing at all about Access. My general approach to data is to do everything in Excel, and write my own code for anything I want it to do. So far I haven't come across anything that I want to do that can't be done that way, but then I've never tried to do exactly what you have in mind.

sss555s

My guess is 98% of people who don't know how to use Access but want something done in Access, should really be looking to do it in Excel.

Ok 97%.

Me included BTW.

Welcome to the thread sparrer.

Nikkster

Hello Sparrer :wave:
Welcome to the Nice People thread

Thanks for mentioning the RSPB HQ - I moved to the same county as you a couple of months ago and that looks like a nice place to go (might leave it until the weather picks up a bit though!).

misskool

michaels wrote: »

Does anyone else feel cheated over the length of the xmas break - when it started it seemed like ages but with the first 3 days spent rushing round madly getting ready, the next 2 spent doing and the one after spent clearing up it somehow turned in to a 3 day break and yesterday I fitted in a trip to the dentist that was about a year overdue so now it is just a normal weekend (with the normal weekend chores to do) and back to work on Monday with a lot to do in January and no relief in sight

me here I was a tad optimistic about my lecture writing skills. Done 3/4 of first one, 1/2 of 2nd one and a smidgen of the third one

silvercar

Welcome sparrer! OH works in Beds, though we live in south Herts.

I am getting over my virus and OH is now coughing and spluttering!

Game of who resists longest and decamps to spare room to get good night sleep. I usually win as I think the sound of his breathing/ snoring is reassuring, whereas he just thinks (my delicate breathing) is keeping him awake. He then moans in the morning that sleeping in the spare room means he hears the kids cluttering around in the kitchen at all hours.

silvercar

I ventured on the pepipoo forum for help with a council parking ticket. Scary lot over there, have returned with tail between my legs.

Still think it most unfair that:

a. traffic wardens are out at 2am
b. if you don't see the PCN on the windscreen (or its removed) you have no opportunity to pay reduced rate

(Just to add, this is or course a parking ticket that DS1 managed to get, because I wouldn't be so careless and wouldn't be out at 2am. Before you ask, it ends up in my lap because he is doing an internship so has no money.)