Problem with using parameter in query with calculation from date

[MsT]

Hi

I have a database with a Date of Birth field. I have a query with a field that calculates the age from the Date of Birth (DateDiff("yyyy",[Date of Birth],Date())+Int(Format(Date(),"mmdd")<Format([Date of Birth],"mmdd")) and it works fine

As a criteria in this field I want to be able to select a minimum age. It works fine when I do, for example >=9. However when I do >=[ ] instead, the query does not work - it treats it as =[]

Anyone have any ideas about this?

Thanks in advance
Fran

 

[mole999]

it needs a value in there, or a way of divining a value otherwise i can't calculate

 

[MsT]

Sorry I don't quite understand your comment - usually when I construct parameter queries I simply use the square brackets (usually with a prompt inside such as [Please enter a maximum value] and the query asks for a value when it runs, then uses that.

When I run this query, it prompts as usual but then does not use the number I enter in the right way

 

[mole999]

i misunderstood your question, i have no answer then

 

[MsT]

Thanks for taking the time! Appreciated.