Search results

hi, I have 2 tables: Table 1: User Desc AAA apple BBB orange CCC orange Table 2: User Desc AAA apple ZZZ banana Query result: User Desc BBB orange CCC orange So basically, I want all entries in Table 1 that aren't in Table 2. In access, the...

I got it from the sample code section of this forum. Let's just look at the record 1 Fuller Andrew Class ABC 2/19/2007 1 Fuller Andrew Class ABC 8/30/2006 1 Fuller Andrew Class ABC 3/19/2006 The filter should only show LastOfClassDate 1 Fuller Andrew Class ABC 2/19/2007 Then when I use the...

Hi, In the query table... the expression is: Age: DateDiff("yyyy",[DateOfBirth],Date())+(Format(Date(),"mmdd")<Format([DateOfBirth],"mmdd")) This only output the number of year. How can I write to output number of days? Thanks, Jessica