![[dr. bob]](/dr-bob-sm.gif)
Dr. Bob is Robert Hsiung, MD,
bob@dr-bob.orgShown: posts 1 to 6 of 6. This is the beginning of the thread.
Posted by Racer on July 7, 2004, at 13:56:04
I *do* have all the things working that I want for the forms and tables, and I've got most of the queries worked out -- but the reports have turned into a problem. Heheheh, but that's only because I want something the program really isn't designed to produce. If I were doing what the program can do, it wouldn't be a problem...
Here's the thing: when I say I want to make myself a "Mood Chart" I mean I want to make CHARTS of my moods, graphical representations. Now, I can make the charts -- that's not a problem. The problem is that I'd like to be able to make a template that let's Access make the charts for me automatically, so that I don't have to make each chart myself. Does that make sense? I figure there's a way to do it -- I just don't know the way to do it. Do you? If you do, can you help me with it?
I suspect, of course, that this is a case of "You just gotta *program* it -- and I'm what my husband describes as a "super user" in that I can work out how to work with the program, but I'm really not a programmer beyond scripting and markup languages -- which is very different from actual programming. So, if it's a case of actual programming, it may be beyond me, it may be that my husband can help me enough to get it done, but I don't even know where to start looking for information about how to do this. If I tell you some of the specifics, would you be able to tell me either how to do it or where to look to find out how to do it?
Thanks, Ms Prince.
Posted by NikkiT2 on July 8, 2004, at 13:39:59
In reply to Nikki? Can you help with Access again?, posted by Racer on July 7, 2004, at 13:56:04
Eurgh.. Internet been down all day.. stupid stupid ISP.. stupid people who know nothing!!!
Anyway.. I hate to say it, but I know NOTHING about Access reports.. I've always used an external report tool - CRystal Reports.. charts are easy peasy in that.. no idea about Access though..
many many apologies!
Posted by Racer on July 8, 2004, at 14:05:34
In reply to Re: Nikki? Can you help with Access again? » Racer, posted by NikkiT2 on July 8, 2004, at 13:39:59
LoL!
OK, here's another problem I'm having: when I try to run a query that lists dates on which my mood has been especially low, along with any notes for that day, it repeats the information over and over again. I think it's because the dates come from the daily record table, the moods from a table that has multiple entries per day, and the notes from another table all together. Since the number of entries for each day on the mood scale and the notes table won't match, it shows [xy] rows instead of [x] or [y] rows. Following me? Is there simple way to consolidate that so that it shows, say, each record from the mood table for that date, with as many notes as there are but not [mood*note] rows? Is that making sense? (There are almost always more mood entries than notes for each day, by the way.)
If there is a way, but it would take too long to tell me what it is, no worries. If that's the case, though, can you tell me how to find the answer?
Thanks, Nikki. Glad your ISP is back up and running, though. A few years ago, when I was writing a grant application for the Center, I discovered at 3:45AM that my ISP's email server was down. Since I was frantically trying to keep coordinated with someone else, this was pretty awful for me. I sent an email to the head of the ISP from my excite account -- and he emailed me back in minutes and fixed it within about half an hour! I did lecture him through email that NORMAL people *sleep* once in a while, but that experience also solidified my loyalty to him and his little homegrown ISP. I'll never leave if I can help it.
Posted by NikkiT2 on July 8, 2004, at 16:56:59
In reply to Very well then, how about a query query? » NikkiT2, posted by Racer on July 8, 2004, at 14:05:34
I remember this problem.. its to do with the the tables are linked together when you run the query.. My brain is fuzzy.. but.. when you run a query, does it show you the links between each table?? If so, make sure there is only one link between each table, and that the link is a unique field.. like a reference number for that record.
I hope that leads you somewhere near a resolution.. I may be way off!!
nikki x
Posted by AndrewB on September 8, 2004, at 0:40:40
In reply to Nikki? Can you help with Access again?, posted by Racer on July 7, 2004, at 13:56:04
You might want to import your data into Excel....easy enough. Its built for auto converting data into various types of charts. I think you have the option of keeping your notes in Access, with links to them in Excel.
AndrewB
Posted by Noa on September 11, 2004, at 12:26:16
In reply to Re: Nikki? Can you help with Access again?, posted by AndrewB on September 8, 2004, at 0:40:40
I agree. As an untrained user of MS products, I figured out on my own how to use excel to manage information in tables, and to make tables and charts of various kinds using data entered into excel tables. I know I'm only using a tiny fraction of Excel's capabilities but it's amazing what it will do even with the little that I know how to use. It gives you all kinds of choices for how you want your data illustrated, and you can change the formats to suit your needs. It makes really pretty graphs and charts, btw.
This is the end of the thread.
Psycho-Babble 2000 | Extras | FAQ
Dr. Bob is Robert Hsiung, MD,
bob@dr-bob.org
Script revised: February 4, 2008
URL: http://www.dr-bob.org/cgi-bin/pb/mget.pl
Copyright 2006-17 Robert Hsiung.
Owned and operated by Dr. Bob LLC and not the University of Chicago.