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

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

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

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

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

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

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