I will try to explain the best I can. Hope you guys can help! I have a database of animals for research. They want me to be able to tell them how many were alive by project per month. These are the fields:
fldDOB (Date of Birth)
fldDOP (Date of Pass)
I have no trouble calculating the total number days alive, but if an animal was born on 1/1/2010 and died on 2/10/2010 I need to be able to tell them that the animal was alive for 10 days in February.
Seems pretty simple, but I can't do it. Hopefully someone here a lot smarter than me.
Thanks!