create query with sum divided by another number

[D. M.]

I have created a property management database. I have created a query to sum
lease payment fields for each year (rent, utilities, maintenance, insurance,
etc.). That was easy enough. Now I've been asked to create another report
which shows the sum of lease payments per square foot (there is a sq. ft.
field in the table).

Can anyone help me with this?

Thank you.

 

[Jeff L]

You will need a field on your report that has
=[SumOfPayments]/[SquareFeet] in it. Obviously, you will need both
fields as part of your reports record source.

 

[Duane Hookom]

Sum the lease payments and divide it by the sq. ft. field. Please try this
and come back with issues, fields, sample records etc so that we know more
about your application.

 

[D. M.]

Thank you Duane. Jeff was right on with his answer. I was trying to do the
calculation in the query. I hadn't thought about calculating the figures on
the report itself. Silly me.

Thanks all!