NickDenyer
Registered User.
- Local time
- Today, 06:19
- Joined
- May 2, 2012
- Messages
- 57
Dear All,
I require your vast, collective intellects!
I have the following age calculation query:
Age: (Now()-[DOB])\365
It works a treat! However, I do not want this to continue to caluclate if the record has them as deceased - I want it to stop at their date of death.
I have a tick box that when selected indicates that this record has died, and a field where you can enter date of death.
Is there some way that via clicking this button, or by entering a date of death, I can stop the Age Query from calculating for just that relevant record, not all of them? If so, could you please show me where to place the neccessary VBA, etc? I can't think of a solution!
KINDEST THANKS!
I require your vast, collective intellects!
I have the following age calculation query:
Age: (Now()-[DOB])\365
It works a treat! However, I do not want this to continue to caluclate if the record has them as deceased - I want it to stop at their date of death.
I have a tick box that when selected indicates that this record has died, and a field where you can enter date of death.
Is there some way that via clicking this button, or by entering a date of death, I can stop the Age Query from calculating for just that relevant record, not all of them? If so, could you please show me where to place the neccessary VBA, etc? I can't think of a solution!
KINDEST THANKS!