Extract data from table instead of prompting in Query

[maarcmade]

Hi,



I have the following expression in Query to compute the age of a person,

Age: DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],"mmdd")>Format(Date(),"mmdd"),1,0)

but when query is executed, it prompt me to input the DOB. I already have a DOB in a table, I wish that instead of prompting me for the input, it gets the information from the table. Any idea how I should go about doing it. Thanks in advance for your advice.

Best Regard
Marc

[pbaldy]

The table containing the DOB field would need to be in the FROM clause of the query (displayed at the top in design view).

[maarcmade]

Hi,

Can you specified what you mean by "FROM clause of the query (displayed at the top in design view)", I'm abit confused. Thanks

The table containing the DOB field would need to be in the FROM clause of the query (displayed at the top in design view).

[pbaldy]

What table is your DOB field in, and what's the SQL of this query?