I have a small db with a form and a subform
When data is added to the subform, i need a little warning light that tells my user that they have exceded the max amount for that day.
Example:
Fields in Subform
schedshipdate
deliverydate
qty
pkgwt
pounds this is a calculate field (=[Qty]*[pkgwt])
tons (this is a calculated field (=[Qty]*[pkgwt]/2000)
I need some sort of redflag that if the tons field is > 100 then flash red,if not then stay green. or something like this... This needs to be referenced off the schedshipdate.
So somehow I need to total all the tons for that schedshipdate and then do the conditioning
When data is added to the subform, i need a little warning light that tells my user that they have exceded the max amount for that day.
Example:
Fields in Subform
schedshipdate
deliverydate
qty
pkgwt
pounds this is a calculate field (=[Qty]*[pkgwt])
tons (this is a calculated field (=[Qty]*[pkgwt]/2000)
I need some sort of redflag that if the tons field is > 100 then flash red,if not then stay green. or something like this... This needs to be referenced off the schedshipdate.
So somehow I need to total all the tons for that schedshipdate and then do the conditioning