Running multiple queries in form

[daniejm]

Hi all,

I appreciate your help.

I've got a DateRange Form built. It allows me to enter two date values and then retrieves all records on or between the defined dates. Now I'd like to accomplish a second task with this form...

In my table I have a date of birth column ("DOB"). When running the form for Date Range, I'd also like to take the DOB column and produce an Age in an "Age" column. However, I only want it to show me the Age value for the records that are being returned by the Date Range query. Ideally: Access would find the "xdate" (dates within datee range), look at the DOB, calculate the age, then spit that out in my results. I hope this makes sense. Example:


DATERANGEQUERY FORM
Start Date: 1/1
End Date: 1/3

Returns:
[DATE IS 1/1 TO 1/3] [CUSTOMER NAME] [AGE]


I've tried the following expression to make the Age column populate, but it blanks out my "xdate" column AND the "age" column. Basically, adding this expression breaks my query and my form -- no errors, just no results. Here's the code I'm trying for the Age:

DateDiff("yyyy",[DOB],Date())+Int(Format(Date(),"mmdd")<Format([DOB],"mmdd")

Help!

[ssanfu]

If I counted correctly, I think you are missing a closing parenthesis

DateDiff("yyyy",[DOB],Date())+Int(Format(Date(),"mmdd")<Format([DOB],"mmdd"))

If the query still doesn't work, post the SQL of the query.

[June7]

The expression you show makes no sense to me. I have tested the expression and can't get a value that is less than Format([DOB],"mmdd")

You want to show records where DOB mmdd is between the given mmdd start and end, regardless of year?

DOBmmdd: Format(DOB,"mmdd")

Criteria for DOBmmdd: BETWEEN '0101' AND '0103'

[daniejm]

Hey all,

Sorry for the late response. This is working now.

Thank you for your help!