I am needing a field on a form to pull the last date of contact from a table or query. It is the last date a customer was contacted however there maybe many date, but I need the most current date. Any suggestions?

group by Min or Max

My problem is that i don't know how to tell that field (that is not in the same table) to find the same customers ID find the last field and show that one. When i created a query and directed the field to the query (which worked fine) I had an Name# error. What do I do now?

I'm not sure exactly what you want..

i think the Name# error means it did not recognise the field.

Here is what i think you should do.

1. Build a query that accepts the name of the customer you want to look at.

2. Make sure it returns the right result.

3. Build a form that passes the name of the customer to the query


I pressume that you have done parts 1 and 2...and you now need to pass the customer name to the query?

I think I have replicated your problem.

Here is what you need to do.

On the field you get Name# error

Change the data source to MaxOf(name of your field)

Thanks, I will give that a try.