Sum of one field based on date in another field

D

D. M.

I am working on a property management database. There are approx 150
properties. I've created a report which shows the financial information for
each location. I'm trying to create a few calculated fields in the report
footer, one of which I can't figure out. I would like to sum the total
square footage of properties which opened prior to a certain date. The
fields for this calculation are [Square Footage] and [Outlet Open]. I'm not
sure where to begin with this. Please help!!!
 
D

Duane Hookom

You can use a text box with a control source like:
=Sum(Abs([Outlet Open]<#1/1/2006#) * [Square Footage])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
Sum equation in reports 1
Sum one field if another field is equal to something 10
Sum in Report Errors 3
Suppress printing group footer using Calculated field(s) 1
sort by sum of a field 1
Sum in report 10
Ignore null field in calculation 4

Top