Rummy

I find it amusing. To both recieve and do. It's a shame people like to be like that, but what else are you gonna do?

Where ARE you?

Not going to believe for a second this is actually Claire.

Playing through SR2, I definitely get a solid vibe of this. Getting more and more excited for SR3 tbh.

Take your kids to work day? CuteRoulette is a dangerous place. Cube should get in here with his cats too!

Voye:No lynch

Lol. Tbh I still have so much more to play in this and just...never got round to it. Think I only ever defeated one king/boss thing?

I don't understand it much myself. I used to be convinced I didn't like it(except for mixing ketchup with for makeshift sauce) but recently I've had to buy sandwiches from shops and they always have mayo in them and I'm sort of growing to like it(in small amounts) but I still don't entirely understand it.

I don't do cheese, but in McD's favour their buns have a weird sweet edge that I quite like.

Does that mean I'll be not so happy with five...?

Really? I do think yes, BK are a bit more expensive and if I'm budget/looking for a quick fix I'll go McD's, but tbh I think the BK burgers are far superior. I dunno if they season them or if it's just the way they flamegrill them, but they feel much more satisfying for me than a McD's one.

I concur somewhat. Absolutely fantastic point. Could fit that so perfectly.

Samsung TV I see. She's still awesome. That kitten could end wars! Hopefully the sickness thing is just a little kitten cold or something, sure she'll be fine. Sad to hear though Hope everything turns out ok.

What! BK fries are so superior. Crunchy, tasty, kings! KINGS! McD's are too salty, KFCs are too...something I can't place. BK any day mate. Though tbh for the prices compared to other options(crappy kebab shop food, pub food etc) I tend to not feed fast all that often.

I think I got a little lost there, but I used MONTH() to pull the month out, as actually the only dates I'll eventually end up using will span a year(sept 10-aug 11) so there won't be confusion. Also realised I can do it in access with crosstabs, but definitely good stuff learning(just about, still don't fully understand) Pivot Tables.

Every time you post a thread that begins with a video that is frozen on a frame of your face I hate you a little bit more. Whore. Also fast food needs to be faster. Also BK>all.

Please sir, can I have some more?

Yeah man, totally agree with all of that! I might hit up 5 to make sure you don't surpass me :p

Happy birthday gents.

Essentially, I need the data in the above sort of format. Even if it wasn't yes no, just a count of occurences would be ok cos I could see where 0s are and make that a No and anything else a Yes. The data is currently in a format like this(either in table or spreadsheet); ID Person DATE Result 598 07 14/09/2010 0.670000017 600 686 07 31/01/2011 0.529999971 600 70 26 18/01/2011 0.360000014 2440 39 22/02/2011 0.409999996 594 55 20/12/2010 0.660000026 800 4036 55 10/05/2011 0.660000026 25 19 28/09/2010 0.219999999 26 19 03/03/2011 0.75 3348 42 01/06/2011 0.400000006 1805 64 27/10/2010 0.779999971 3039 64 02/03/2011 0.769999981 4441 11 17/12/2010 0.039999999 486 46 08/09/2010 0.419999987 The ID is irrelevant, that's access's primary keying/autonumbering. The Person ID/number and date is relevant. I need to make a table that has the Person IDs as rows, and then months as coloumns, and either counting up the occurences and putting in the relevant column to show how many entries they are for them in that month. If that makes sense. The result is also irrelevant for the present need. Those 600s/800s are also irrelevant. ADDIT: Been playing in Excel with PivotTables, think I've sort of got what I need to do down. It's just a practise run anyway for something a little down the line. They're pretty impressive beasties though!

Ah, so free talk? Then the next riddle arrives at night time? Seems interesting so far. Was there a consequence to using the hint dialogue?

Mmm, some of my searching turned up PivotTables and it looks like they might be the way forward, unfortunately I know nothing about them at the moment. The data's actually already in a database, so if it's a function I could do there instead then it'd be easy(results in one table tied to person identifiers(person 1, person 2...etc), and there's also a table with all the information/demogrpahics for a person, though that's a bit irrelevant I think).

I get what Moogle's saying.

Seems to be that I'm the new ReZ