Making a field pull a last date from a table (1 Viewer)

[mrssevans]

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?

 

[Anauz]

group by Min or Max

 

[mrssevans]

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?

 

[Anauz]

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?

 

[Anauz]

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)

 

[mrssevans]

Thanks, I will give that a try.