Report

[Guest]

I am new to Access.

Is it possible to create a report that does the following:

 

[Duane Hookom]

You can do this in your query or in your report. You would need to apply the
appropriate ()s and there might be issues with possible Nulls in the field
values.

BTW: calculating across fields like this sometimes suggests un-normalized
table structures.

 

[Guest]

thanks but how do I actually do this ?

You can do this in your query or in your report. You would need to apply the
appropriate ()s and there might be issues with possible Nulls in the field
values.

BTW: calculating across fields like this sometimes suggests un-normalized
table structures.

 

[Duane Hookom]

Create a column in your query like:
MyResultFieldA+FieldB+FieldD+FieldE) /
(FieldA+FieldB+FieldC+FieldD+FieldE+FieldF)