Posted by ice on 12/26/06 16:23

Hello,
I have a couple of tables. The client tables and the contacted
tables.
I am not sure how to start on this, what I need is a way to query all
my clients
then show any client that the last visit and or called day is greater
than 30 days.
Now it gets confusing, Suppose the client was visited more than 30 days
ago
but was called only 10 days ago, I really would like to have this
appear on the same
query.
So the report would look similar to this below.
Visit Date Called Date
ClientA 2006-11-02 2006-12-16
ClientB 2006-12-17 2006-10-30
ClientC 2006-10-15 2006-10-16
ClientD

Fields (Simplified)
Clients: Name, Address, Phone.
Contacted: Name, Date, Visit, Call.
I need to query all l names, but I only need the last visit and last
phone call. Then determine if either date is greater than 30 days if
so, display the last date of each type of contact. And if there is
nothing for the client in the contacted table this needs to show also,
ClientD.
Any tips, ideas would be greatly appreciated....
Thanks
Ice

[Back to original message]