var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: calculating remaining value in one field, based on second field
I am trying to calculating the remaining value in one field, based on second (Boolean) field in the same table.
Row1 data: F1, F2, F3, 24, True (F= Field)
Row2 data: F1, F2, F3, 10, False
Row3 data: F1, F2, F3, 3, False
I want to my query to display F1, F2, F3, 11
I am using Access 2003
I have no idea where to start.
Basically (with F4 being the numeric column and F5 the boolean column):
But you don't explain how to group the values in F1, F2, F3.
SELECT Sum(IIf([F5]=True,[F4],[F4]*-1)) AS Total
Have a nice day!
works like a dream. the other fields aren't important, I can group on the one I want.
It gives me exactly what I want.
Tags for this Thread