reasking an Access Question

[scottcraft]

I am new at this so I appologize for not giving enough information. I am in the US Army and developing a reporting system that shows when soldiers are due periodic physicals (required every 5 years) and annual Physical Fitness Tests. The date for each LAST_PHYS and APRT are in a text format with each YYYYMM. The information is downloaded from a larger data base and reduced only to the 1,800 or so soldiers I have. I want to be able to create a query that show soldiers who HAVE both and are current and also create a report which shows when one or both of the entries are expired. I hope this provides enough info for someone to assist.

thanks

 

[SkipVought]

Hi,

IN your query convert LAST_PHYS to a real date and compare to DATE() in the Where caluse

...
Where DateDiff('yyyy',DateSerial(left(LAST_PHYS,4),right(LAST_PHYS,2),1),Date())>=5

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}