Sum data under special condition

S

SF

Hi,

I have a main and detail subform. In the subform I had a Check field (Yes/No
field) from the under laying table. I am having a problem of putting a
sum(amount) on the main form for only item that has a check in the Yes/No
filed.


Could someone advice?

I have Access 2003 on XP box.

SF
 
B

Baz

A Yes/No field has a numeric value of zero when it is "No", and -1 when it
is "Yes". So, to achieve what you want, simply multiply the amount by the
Yes/No field, and by -1 e.g.

Sum(amount * yesnofield * -1)
 

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

Subform 7
populate to all rows in the subform 4
How to validate sum of fields (access 2003) 1
Access Main and subform subtraction and balance 2
sum subform to form 4
how do i open a subform based on a yes entry in a field in main fo 2
problem in unlinked subform 0
sum won't update 1

Top