Nice people thread part 3- Nice as pie

Wheezy_2

Rock guitarist Gary Moore dies

http://www.bbc.co.uk/news/uk-northern-ireland-12377862


R.I.P. Gary

vivatifosi

PasturesNew wrote: »

Well, I've not really "used" MS Access since about 2003-2006 or so, I've got a copy of 2003 and I just used it to keep my bookmarks so they were searchable (I had about 3000 bookmarks), but I've not even bothered using that to look things up for the past 5 years.

Goes to show how differently our collective minds work! I keep my bookmarks in Word and use hyperlinks to topics to make them searchable.

vivatifosi

missk, having another look through the incs and the excl, can the same thing appear in different columns? That's one place it could get a bit messy.

silvercar

And my library is closing two mornings a week and shutting earlier on some other days but they consulted first so that's OK. **sarcastic smiley*

PasturesNew

silvercar wrote: »

And my library is closing two mornings a week and shutting earlier on some other days but they consulted first so that's OK. **sarcastic smiley*

What hours is it open now then?

The library here's never been open long. It's only about 30'x30' and is open Mon/Tue/Thu/Fri 9-6, Sat 9.30-12.30. It's closed on Wednesdays and Sundays. So total opening hours is (4x9)+3 = 39 hours/week.

LydiaJ

Sorry to hear that, silvercar.

Since we're all discussing databases and spreadsheets, can I ask an Excel question, please?

I have a couple of columns on a spreadsheet from which I want to create a graph. One column contains dates, and the other column contains a money balance. The dates are not regular - there is always an entry for the first of every month, but sometimes there are other entries during the month as well. Sometimes there is more than one entry on the same day.

I want to create a graph to show how the money balance is changing. So I want a series of flat lines, not a zigzag. If the balance is £x on 1/1/11, changes to £y on 14/1/11 and then to £z on 1/2/11 then I want to see a flat line at £x from 1/1/11 to 14/1/11, then a vertical step to £y, another flat line at £y and a vertical step to £z etc.

The only way I can think of to do this is to create a second pair of columns in which each date appears twice, for the top and bottom of the step, and then use a scatter graph with straight lines. While I could very easily write some VB to generate these extra columns automatically, it feels inelegant - and it will end up with those columns twice as long as the original data. Is there a way of creating a graph like that directly from the source data?

Thanks!

PasturesNew

I've no idea - I'd just create a graph, see what happened, then adjust it until it did it

I've used Excel since version 4, which was early 90s and it changes so much (moving things around etc, new features). I have Excel 2003, you're probably posh and have a legit version newer

tomterm8

Do you mean a bar chart?

tomterm8

Misskool, do you and pasturesnew know each other in real life? Because if you do, these kinds of problems are much easier to sort out over a nice cup of tea, face to face. It's the reason I stay out of the tech boards, you just end up getting more and more confused. I think PN is more than capable of putting you on the right track face to face, whereas I am pretty sure we could end up confusing you completely on here.

(I'm especially bad at explaining things when I am not face to face, because to be honest half the time I'm not aware of what I do to get a particular result... I just know what to do, and do it, and when I try to explain things it all comes out as mush. I need a computer with the info in front of me).

PasturesNew

tomterm8 wrote: »

Misskool, do you and pasturesnew know each other in real life?

Nobody knows me in real life, I live in the 4rse end of nowhere, always a minimum of 200 miles from anything. When you see my name think "Lands End, last cottage at the edge of the field".

tomterm8 wrote: »

these kinds of problems are much easier to sort out over a nice cup of tea, face to face. It's the reason I stay out of the tech boards, you just end up getting more and more confused. I think PN is more than capable of putting you on the right track face to face, whereas I am pretty sure we could end up confusing you completely on here.

I stay out of there too - and it's why I said earlier I am staying out of the DB help.

tomterm8 wrote: »

(I'm especially bad at explaining things when I am not face to face, because to be honest half the time I'm not aware of what I do to get a particular result... I just know what to do, and do it, and when I try to explain things it all comes out as mush. I need a computer with the info in front of me).

Every version's different; what people say isn't what they mean; what they're trying to do can be done better/simpler another way .... I never do remote support.