Conditional Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Propoflady - 04 Apr 2006 20:48 GMT

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

Reply to this Message

Br@dley - 05 Apr 2006 12:10 GMT

> 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
[quoted text clipped - 4 lines]
>
> 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?)

Signature

regards,

Br@dley

Reply to this Message