Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Back to basics: I think I need my hand holding to get an access report

Back to basics: I think I need my hand holding to get an access report

Back to basics: I think I need my hand holding to get an access report

Back to basics: I think I need my hand holding to get an access report ready by the end of this week!

Dear All, it occurs to me having read the feedback to my earlier questions (and the input is VERY much appreciated) that I really need to learn some basics.  fast.

The solution I need to design is probably quite straightforward - data from tables (input will be manual - once I've crossed this bridge I'll look at collectin gthe info using ASP) needs to generate a report.

The fields are all numerical, but some have to be combined.  eg. field1, field2 and field3 need to be combined to make a total.  However, i've tried to put the formula into the table (like one would in excel) but it seems this is not the way to go!
So- is this something that I need a query for?  or can the report generate this?  and where in access do I telel the program to add three values and present the resulting figure?  I'm aware somewhere there is an engine so that i can quickly enter  = [field1] + [field2] etc., but I really don't know whjere.  Certainly not in tables!

If someone can give me a blow-by-blow of how the (for example) four calculated values are produced in the report from (again for example ) 24 fields (field1-field24) from the raw data stage, I'd be eternally grateful!

thanks once again everyone,  neil

RE: Back to basics: I think I need my hand holding to get an access report

Have you tried using the report wizard.  Go to the reports tab on the database window and click New.  Then click Report Wizard.  The wizard should get you the basic report then you can add to it.  Are you talking about summing up the values for several fields on the same line and displaying the total?  This is fairly straightforward.  Look at your report in design view.  In the toolbox, select textbox.  Then draw a textbox in the detail section of your report.  Put a label in the header above your textbox and type in whatever you want that column to be called.  Right-click on the textbox and select properties.  Set the Control Source property to =[Field1]+[Field2]  or whatever your field names are.  Now when you display the report, in each row, that column will have the sum of Field1 and Field2.  Is this report based on only one table.  If so, the record source property for the report should be the table name.  If not, the record source for the report should be a SQL statement or a query.  Then you can use any of the fields returned by the query in the control source of the textboxes you put in your detail section.  If you have any more questions, let me know.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close