Why use the ">=" and "<=" when "Between" and "And" are keywords that do the same thing, and make the criteria much more readable (if you forget what the symbols mean you are out of luck). Use the criteria exactly as I gave it to you before and it should do the same thing, but make it more readable when you try to remember a year from now what you were doiing in that query (after spending nine months away from it).
Also, are DOB1, DOB2, and DOB3 separate FIELDS in the same RECORD, or are they the same field in different records? If they are the same field in different records it should work, if they are in the same record, I am not sure why you are holding multiple DOBs in one record. HTH! Alienwebmaster --- In [email protected], "Hassan" <[EMAIL PROTECTED]> wrote: > > Thanks Alienwebmaster for replying, > I took your advice and made a query with that string > > Age: DateDiff("yyyy",Lifetimetbl.Dob1,Date())+(Date()<DateSerial (Year > (Date()),Month(Lifetimetbl.Dob1),Day(Lifetimetbl.Dob1))) > > with a criteria >=16 And <=25 The string works fine with Dob1,But when > I try to add Dob2, Dob3 etc, it says > > duplicate output alias age? > > How do I fix that? I'm basically trying to run the query for child1 > through child5. > any ideas?? > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
