Parameter

[Mike]

I have numerous fields in my query including division, date, transaction #,
net amount, and balance. I want to be able to enclose a parameter saying if
the 'net amount minus the balance is equal to 0, then do not bring back the
rest of the record. If there is a balance, bring back the entire record.

Thanks in advance.
Mike

 

[KARL DEWEY]

In design view add a calculated field like this --
Just_Checking: [net amount] - [balance]

Then in the criteria row use this --
<>0

If you have other criteria use the same row. If more than one other
criteria the you need to add the same criteria to each row the has criteria.

 

[John W. Vinson]

I have numerous fields in my query including division, date, transaction #,
net amount, and balance. I want to be able to enclose a parameter saying if
the 'net amount minus the balance is equal to 0, then do not bring back the
rest of the record. If there is a balance, bring back the entire record.

Thanks in advance.
Mike

Put a criterion on Balance of

<> [Net amount]