Filter Calculated Field

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.
 

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

totaling in a filtered form 2
Using DSUM to get running total on a filtered form 0
MS Access 2007: Calculated field based on subform: 1
Filter Field Selection from Previous Field 2
Select a field in query using combo box 4
iif exists - too complex? 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
Conditional Totals in Subform 0

Top