Active and inactive fields

[dgil]

I have an advertising database for classified ads. I have it calculated to figure out the income each month. However, some of the ads that I have do not actually run. Is it possible to create a field to make the ad active or inactive?

IF so, please instruct - I am very very new to FM

Thanks in advance!

[mr_vodka]

How exactly do you have it setup to calculate each month?

For clarification, you basically want it to calculate only records that have an active status correct?

Please supply as much info as possible and the methods of how you intend to you it.