last contact

[mitchy1111]

Hello,



I have a table which contains all our customer contact history, i.e. each time they contact us a record is created with the date and details. How can I query this data to show the last date that each customer had any contact with us?

Cheers

Martin

[dcrake]

Use the group by customer and last appointment date in your query

[mitchy1111]

Hi David,

I don't have a last appointment date field in the table. There will be several contacts for each customer, I need the query to give me the last contact for each customer. Probably dead simple.

Thanks for your help

[dcrake]

No you don't grasp what I am stating. Create a new query and use the Sigma buton from the tool bar to create a group by query first bring down the cutomer id field then bring down the apppointment date field and change it rom group by to last or max.

David