I have made a cross tab query with MS Access to sum data, producing totals for grades A, b,c,d, and e for each ward in a hospital. However I would like to add final columns and rows totalling the totals number of cases from A-E, similar to how it would look on an Excel pivot table. However while I can produce data for individual columns I can’t seem to produce totals. Any help gratefully appreciated – please bear in mind I have no knowledge of VBA and am using in built tools only (including macros if needed).

i have a form where many users are using. There is a button there that when clicked, the form’s serial number will be incremented by 1 and will be printed. I want that user can only print this form using the button I have provided and that if a user use Ctrl+P or click the printer icon in the tollbar, excel will not print and will rather ask them to click the button provided. A million thanks to those who can provide me the vba code for this. I will treat it as your greatest christmas gift to me. Thanks.

I have created several databases and programs in MS Access 2000/2003 that store information, call the windows command line to run other exe and batch files, run reports, and export data to excel files. I would like to move to a web-based system and/or a stand-alone exe system without “MS ACCESS” being in the background.
I have 2 books from the library.
- Teach Yourself Visual Basic.Net 2003
- ASP.NET in 50 minutes a day.
Both of these are hefty books (almost 1000 pages each).
Am I going in the right direction? What are the differences in these 2 programming languages? It appears they can interact, so which should I learn first?
I have some knowledge of website design (through FrontPage) and moderate skills in VBA programming behind the scenes in Access 2000/2003. Thank you!