Find Access table record by Date function

[rodgs]

I have an Access table in which one field (fldDate) is the date. I need to locate the record that corresponds to the fldDate being 12/31 of last year and then print the value of field D1 of that record. I can determine the date easily enough by using DateAdd("yyyy",0,date()-DatePart("y",date())) but I seem to lose date formatting or something because it doesn't work for locating the proper record. What should the procedure be to locate the record?

 

[PHV]

What is your actual code ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886