D
DPCpresto via AccessMonster.com
My query has two fields [prop_id] and [comsdate] where the comsdate field is
a date that periodic, recurring maintenance was done on a certain property.
In some instances, the property is listed twice because I had used a criteria
of >= 1/1/2008. My problem is that i want the query to list all properties
that I manage, but, in those instances where the property may show twice, I
only want the LATEST date to show in the query. I then use these results to
schedule the next time maintenance needs to be done by using [comsdate]+120.
I just can't seem to get the multiple listings out.
a date that periodic, recurring maintenance was done on a certain property.
In some instances, the property is listed twice because I had used a criteria
of >= 1/1/2008. My problem is that i want the query to list all properties
that I manage, but, in those instances where the property may show twice, I
only want the LATEST date to show in the query. I then use these results to
schedule the next time maintenance needs to be done by using [comsdate]+120.
I just can't seem to get the multiple listings out.