Propoflady wrote:
I have a database that has tables, contact event and last date of
contact. Then I have a report where I can print current contact and
event. If the last date of contact is less than 3 months previous I
want to ignore this event. Is it possible to make the dbase go look
at the field of last date of contact and if less than three months
then put in last date of contact?
All help appreciated
I found that a little difficult to follow...
So you have a table of contact dates for each person and a table of people?
You can do this in the query behind the report.
Create a query that returns the PersonID, Max([ContactDate]) for each
person. Create another query and add the people tble and you previous query,
joining them by PersonID.
Then in this query create a new column:
DateTest: DateDiff("m", [LastContactDate], Date())
Where: > 3
(not sure that last bit will work exactly since I forget how DateDiff() will
behave, eg. if it's 3.2 months will it return 3? Might be better to work
with days?)
--
regards,
Br@dley