Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Displaying age in months or years using DateDiff
Ok, I'm not sure what happened to my first thread, but I am going to post again. I currently am using the Date diff formula to get the age of patients. =DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) This displays the age of the patient in years, so if the patient...- SaneN85
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Counting checked boxes
Hi, I am new to this forum and was hoping that someone would be able to help me with my Access issue. I have a form/table set up to count the number of immunizations are given. The immunizations are set up as checkboxes and I need to be able to count the number of each separate immunization...- SaneN85
- Thread
- Replies: 14
- Forum: Microsoft: Access Queries and JET SQL
