Tags: 150properties, access, approx, based, created, database, date, field, financial, ive, management, microsoft, mysql, oracle, property, report, sql, sum, working

Sum of one field based on date in another field

On Database » Microsoft Access

1,298 words with 1 Comments; publish: Sun, 01 Jun 2008 10:09:00 GMT; (25047.00, « »)

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!!!

All Comments

Leave a comment...

  • 1 Comments
    • You can use a text box with a control source like:

      =Sum(Abs([Outlet Open]<#1/1/2006#) * [Square Footage])

      Duane Hookom

      Microsoft Access MVP

      "D. M." wrote:

      > 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!!!

      >

      #1; Sun, 01 Jun 2008 10:10:00 GMT