Last Time a Reason a Customer calls in a day

[gmazza76]

Good morning/afternoon,

Bit of a query I am going round in circles with if that ok.

I have a database that holds the following information
[Date],[Account No],[TimesCalled],[Reason]
But I only want to pull the last time the customer called in a day based on the above fields.
My understanding would be the output of [Reason] based on the data in [Date], [Account No] matching and the highest value in [TimesCalled] (usually between 1 - 10 but this can differ).

Any idea what would be the best way to come at this?
Thanks in advance
Gavin

 

[jackd]

??I'm not following your structure. If a person calls each day for a week -1 time monday, 10 times tuesday, and 1 time each other day, each call could be a different reason. Do you want the last call on Friday, or the 10th call om Tuesday?

If the call could be for a different reason, then I would suggest
AcctNo, Date with Timestamp, CustomerId or Name, Reason for the Call.

You would use a query to Count the Calls per Day.

 

[alansidman]

Sample data and expected output would be helpful.

 

[gmazza76]

Thanks for looking, but I have used "Max" in my query to filter only the last entry on the day based on the "CustomerID"