Filter Calculated Field

  • Thread starter Thread starter Allan Koodray
  • Start date Start date
A

Allan Koodray

I am attempting to create a subform whose filter would be
based on a calculated field. The parameters are as such:

The table the fowm is based on contains the following:
Account
Monthly Buckets (jan - dec)

The form includes each of these fields, plus a total by
account.

I wish to create a filter that would limit the number of
records to those whose account total > 1,000,000.
 
Back
Top