Bill, I have the date set to calculate the age at the time of the incident, not today. We need to know how many "suspects" were juvenile versus adult at the time of the contact. Is there a better way to write that?
I agree with Liz that the query is scary but, in my defense, it looks a lot better in query design mode rather than SQL.
Jessica
On Tuesday, May 27, 2014 10:57 AM, "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jessica
You might also want to change your Age calculation to something a bit simpler.
DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) As Age
-Bill
__._,_.___
Posted by: Jessica Hoback <hobackjessica@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar