Advanced Beginner
Windows 7 64bit 
Access 2010 64bit
I have a form that has a sub form on it. I would like to know if there is a way to sum a control but avoid summing a certain record if a field is null? Hopefully that makes sense.
The reason is I always auto fill one field with the previous entry but then that gets summed and I do not want it to until the whole entry is complete.
VIP
Windows 10 Access 2007
Sort of sum (controla,controlb and if controlc isnotnull then controld)
??
Sent from my iPhone using Tapatalk
Very Inert Person
Windows 7 32bit Access 2007
in a textbox, =DSum("myField", "tblMyTable", "SomeOtherField IS NOT NULL"
or create a query that returns the total for the records where SomeOtherField IS NOT NULL ?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Show % of current rows in total rows.
Filtering out rows based on values in other rows
Posting Permissions
Reply With Quote