Closed Thread Icon

Topic awaiting preservation: Access question... Pages that link to <a href="https://ozoneasylum.com/backlink?for=7703" title="Pages that link to Topic awaiting preservation: Access question..." rel="nofollow" >Topic awaiting preservation: Access question...\

 
Author Thread
bodhi23
Paranoid (IV) Inmate

From: Greensboro, NC USA
Insane since: Jun 2002

posted posted 03-17-2004 18:50

I am teaching myself to use MSAccess. I've got quite a few very good resources, including some CBT. But I can't find the answer to what should be a very simple calculation. I figure someone here has done it before and can tell me what expression I'm supposed to put in the box.

I've got a simple report, pulling entries from a table. There is an amount column that I have totaled in each group level of the report. ex: =sum([Auth Amt])
I want a grand total to appear in the page footer. What is the expression I would use to get this to happen? All the help informaiton talks about totaling in the group level, and tells you to put the calculated control in the detail section of the report. This appears to only total each group. I want a total of all groups.

Anyone have a suggestion? I'm not having much luck finding this on my own. Thanks!



Cell 617

[This message has been edited by bodhi23 (edited 03-17-2004).]

bodhi23
Paranoid (IV) Inmate

From: Greensboro, NC USA
Insane since: Jun 2002

posted posted 03-17-2004 20:48

Never mind - I figured it out.

Got to put it in the REPORT footer - then it totals the whole list... Do ya ever just feel stupid?

Wangenstein
Maniac (V) Inmate

From: The year 1881
Insane since: Mar 2001

posted posted 03-17-2004 21:39

Trust me, your brain will never work harder to solve a problem than just after you've asked for help.



Evil in theory, not so much in practice...

WULFIUS-KHAN
Bipolar (III) Inmate

From:
Insane since: Jan 2004

posted posted 03-18-2004 11:44

Access is not a serious database.

It stores all data in one massive file, if that gets corrupted, you lose all the data since the last backup.
No transactional backup like the big boys use.
You may think its nothing, I lost a 5 person helpdesk database at 4PM. Learn on my mistakes.
Microsoft advises you use Microsoft SQL database if you do want to do 'real' work.

Still, its a worthy skill, keep it up my friend.

---
"The future is not written in stone.
It is written day by day,
What are you writing today?"
http://wulfius-khan.deviantart.com/
http://www.users.bigpond.net.au/wulfius/

bodhi23
Paranoid (IV) Inmate

From: Greensboro, NC USA
Insane since: Jun 2002

posted posted 03-19-2004 17:39

We use a system here at the Uni called SCT Banner for all of our records. Apparently, it interfaces very well with Access, which is the reason I'm trying to change over the current files to an Access database. Currently, they're contained in an Excel spreadsheet. I figure that moving to Access is definitely making progress, if nothing else. I want to learn SQL, but I better start with baby steps! Doing this crap on one's own is not very easy, even with the resources I have...

But thanks for the votes of confidence - I'll just keep pluggin' along!

Wangenstein
Maniac (V) Inmate

From: The year 1881
Insane since: Mar 2001

posted posted 03-20-2004 06:53

A good baby step for learning SQL is to look at some of the queries you've built in Access in 'SQL View'. It translates the Access query into the SQL equivalent. It's good for getting familiar with the very basics, like structure and how to put together criteria, table links, etc. Personally, I couldn't write SQL from a blank page until I broke down and took a class on it. However, I'm really not a programmer, so I needed the structure of an actual class to help me learn. You might be able to just use a book.



Evil in theory, not so much in practice...

bodhi23
Paranoid (IV) Inmate

From: Greensboro, NC USA
Insane since: Jun 2002

posted posted 03-22-2004 23:00

Sort of like using Dreamweaver's Code View to learn a little about HTML? Though, I must admit, Dreamweaver's code is pretty weird anyway...

But I'm no programmer either. I just have some good computer based training resources that I can use in my spare time. I just have a small amout of student data that I'd like some more flexibility with. So I figured it would be a good way to spend our down time during Spring semester. Teaching myself in my spare time takes a long time...

But knowledge of databases is a good thing, so I'm pluggin' along at it...

But no - not a programmer myself...

« BackwardsOnwards »

Show Forum Drop Down Menu