Query to extract record of particular year

[pkg206]

Hi,



I have a table with fields: name, designation, deptt, date of birth(DOB) and date of retirement(DOR). With the help of query I am calculating the field DOR like ..DateSerial(Year([DOB])+60,Month([DOB])+1,0).. and the month end date after 60 years of DOB is calculating but the problem is that I want to get data for only one year like persons about to reitre in 2010. I got the information if I fix the criteria in DOB field in query and it is working fine (like .. Between [between dates]![month] And [between dates]![MONTH1].. but if I do it with DOR, its not working (may be because I am also calculating the field and putting criteria). Please help

Pankaj

[dcrake]

Once you have your query working without any criteria in it save it and open a new query based on this query and put your criteria in there.

David

[pkg206]

Thanks David, I tried to save the query and the result is fine and I opened another query based on my previous query and put up the criteria .. Between [between dates]![month] And [between dates]![MONTH1].. but again no result are coming. in 'between dates' table both the field i.e. month and month1 are date fields. Whenever I run the sub query based on my previous query with the above criteria, it shows no result. Pl. help (I would like to prefer the command within the table/query/form etc instead of using sql command). Thanks in advance