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

[NeilBelgium]

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

 

[shmiller]

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.
Shanti
smiller@kodak.com