Query (Date)

[conormooney]

I have posted this before and have got help with it before but it wasnt what i wanted.

I have a table with information with animals tbl_herd (EarTagNumber,DateofBirth,Sex,EarofTagging,Deceased)

I now want a query to extract all the animals in this table which are older than 18 months, can anyone give me the criteria for this please?

 

[a.sinatra]

Criteria for DateofBirth: >DateAdd("m", 18, Date())
________
Learning disorders advice

 

[conormooney]

cheers that worked a treat.

my next question is also about dates, i have another table called "table movements"

tbl_movements (EartagNumber,Entered herd, Period of Restriction(days), Elligible to leave herd)

i enter when the animal came into the herd and also enter the number of days it has to be held before it can be sold on, i want a query to add the number of days of restriction onto when it entered the herd and display it in the Elligible to leave herd column. any ideas?