Topic awaiting preservation: Access question...

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).]

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?

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...

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/

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!

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...

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...