Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 6th, 2005, 08:10 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default Grand Total

how can calculate the Grand Total ?

I make report in access and use group by dept.
I have four table to calulate the manhour of each week.
ie

MH1, MH2, MH3, MH4

sub total of report is right.

I use following formula

=Sum([MH1]+[MH2]+[MH3]+[MH4])

I want to Grand Total of each department

How I can get Grand Total of each department which sub total
formula is =Sum([MH1]+[MH2]+[MH3]+[MH4])


regards.

Mateen








 
Old April 6th, 2005, 01:59 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

If you want a total for a department, put the text box in the Detail Section.

If you want a grand total for all departments, put the same formula in the Header, or Footer.

HTH


mmcdonal
 
Old April 7th, 2005, 06:34 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for response.

grand total give right result.

I have three more problem.

1. I make data entry form in access and buttons for insert and
   exit the form. How can disable close option of form.
   form only should be close by press button, form should not
   be close by cross option of top right side of form.
   what properties will change to disable the close (Cross) option ?

2. what properties will change to display full screen form ?

3. I make form the weekly man-hour data entry of each project.
   it will run at Intranet, where 25 employee daily enter
   data entries. Access Form will easily run on Intranet ?
   To run the access form at intranet what necessary properties
   should be configure that it will do quit / right data entry ?

Please any one give your valuable comments.

regards.

Mateen

 
Old April 7th, 2005, 06:50 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

1. Go to the Form Properties dialog box and change Close Button to No.

2. What I do is maximize the form in design view, and then go to the Form Properties dialog box and set Auto Resize to No. There is probably a more elegant way of doing this, since you may have to set all your forms to Auto Resize=No.

3. I don't do Access on the inter/intranet except as a data engine for ASP pages, so I can't really help you there. If your employees are all doing new records (SELECT and INSERT) and not modifying old records, then Access should be fine. If they were doing UPDATE and DELETE, then you might want to go to SQL.


mmcdonal
 
Old April 7th, 2005, 09:23 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your response.

1. Close Button to No, it is ok.
2. Auto Resize to No. it dislay full screen form,
   as well as it also open access application, ie tables, reports
   all database, user should not see the access tables, report etc.
   when user click the form, only form will display with full
   screen, I make short cut to open the form.
   what properties will change ?

3. Yes I am using sql server 2000. all table are in sql,
   I make link the tables ODBC with the sql server.
   only for data entries I use Access Form and Report tool.
   user only insert the records, not update or modifying the records.

regards.

Mateen



 
Old April 7th, 2005, 11:01 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

2. You have to set the auto resize for all the other objects in the database to No, and then manually set their size in Design View using this method. Perhaps another user has a more elegant solution.

3. I use SQL for a repository of data, but I don't put the data on web pages. I know there are some configuration issues. Perhaps there are some reporting tools in SQL to help do this. I know you may need sharepoint to do this these days.


mmcdonal
 
Old April 8th, 2005, 07:30 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, you are right. data should not be on web.
I will make data entry form in ASP.

I want to confirm that there are no such properties in access
to display full screen form ?
form only control by the button ?
no other options, minimize, max, close and cross option.

regards.

Mateen



Quote:
quote:Originally posted by mmcdonal
 2. You have to set the auto resize for all the other objects in the database to No, and then manually set their size in Design View using this method. Perhaps another user has a more elegant solution.

3. I use SQL for a repository of data, but I don't put the data on web pages. I know there are some configuration issues. Perhaps there are some reporting tools in SQL to help do this. I know you may need sharepoint to do this these days.


mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating grand total blkskullwork Javascript 2 December 18th, 2006 10:36 AM
Sub Total Rjh Reporting Services 0 June 21st, 2006 04:11 PM
PIVOT TABLE Grand Total ... pls help !!!! laky Access VBA 0 June 2nd, 2006 03:47 AM
PIVOT TABLE Grand Total ... pls help !!!! laky Access 0 June 2nd, 2006 02:15 AM
Compare parent's attribute with grand parent's one scubaduba XSLT 3 November 29th, 2004 12:26 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.