You haven't said what the problem or result is.
Maybe it's because DateDiff has no format parameter?
EDIT - Somehow I missed that this was marked as solved. It's considered helpful to post a solution when you've solved it - helps others who might have the same issue.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I need help. I have the following DateDiff Function in a MS Access Query Duration: DateDiff("n",[Ticket_Begin],[Ticket_Submitted]), how can I format is it hh:nn:ss? Thanks in Advance...
What you're doing here is called hijacking the thread because you're not the original poster. Better to start your own and avoid potentially confusing those who might post answers based on what they see that was posted by the original poster. It also helps to separate the notification emails for those who originally responded.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.