Can I do calculations in detail feild?

[JCKTM]

I am trying to do a simple calculation in the detail section of a report. I get the expression builder, enter in the formula, and then get an error message. All I am trying to do is divide one number in a detail feild by 100. Is this possible to do, or do I need to do it in the query itself? I hope I don't have to do it in the query, as I am trying to avoid this.

Does Access allow you to do calculations in the detail feild? Or is it only possible to do this in the footers?

 

[bernie10]

Yes you can do calculations in the detail field. In your text box the control source should be:

=[YourNumField]/100

Let me know if I'm not understanding your problem correctly.

HTH,
Collen

 

[dhookom]

Make sure the name of the control is not the name of a field.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[JCKTM]

I still cant seem toget it to work. My formula is the following, which is input in the Control Source. I am basically copying one of the text boxes in the detail section that already works, and then entering in a new formula:

=[Report Query]![Commiment]/100

When I try to view the report, I get the message box Enter Parameter for Report Query. if I skip through the box, I get an error mesage in the report where I want my new calculated feild to be displayed.

 

[dhookom]

I don't understand why you would use "Report Query" in the expression. Commiment must be a field in the report's record source. Use an expression like:
=[Commiment]/100
Are you sure of your spelling? Should this be Commitment?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]