Name: Captur34523523e.PNG Views: 13 Size: 28.9 KB ID: 29680" class="thumbnail" style="float:CONFIG" />
I want to subtract HOURSLABOR - SumOfQTY to get a new column with the remaining for each job
Name: Captur34523523e.PNG Views: 13 Size: 28.9 KB ID: 29680" class="thumbnail" style="float:CONFIG" />
I want to subtract HOURSLABOR - SumOfQTY to get a new column with the remaining for each job
Don't understand the issue. Create calculated field in query that references the other fields or create another textbox and build an expression in its ControlSource property that references fields or textboxes.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Put that textbox in the Detail section. Leave its label in the Header.
Could do the calc in query and then bind textbox to the calculated field.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
=IIf([HOURSLABOR]-[SumOfQTY]<0,0,IIf([HOURSLABOR]-[SumOfQTY]>0,[HOURSLABOR]-[SumOfQTY]))
ok this worked
Now I need to figure out how to total this new column
Would it be like this??
=Sum IIf([HOURSLABOR]-[SumOfQTY]<0,0,IIf([HOURSLABOR]-[SumOfQTY]>0,[HOURSLABOR]-[SumOfQTY]))
Yes
Your expression ignores 0 value. Use: =IIf([HOURSLABOR]-[SumOfQTY]<=0, 0, [HOURSLABOR]-[SumOfQTY])
The Sum would be:
=Sum(IIf([HOURSLABOR]-[SumOfQTY]<=0, 0, [HOURSLABOR]-[SumOfQTY]))
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.