Query works on my machine but not on others with the same version

[GlenLynam]

Hi,

I am trying to execute the following query....

SELECT [SMDR In Order].Party1Name, Format(Sum(TimeValue([Call duration])),"hh:nn:ss") AS TotalCall
FROM [SMDR In Order] LEFT JOIN [Names] ON [SMDR In Order].Party1Name = Names.Name
WHERE ((([SMDR In Order].[Call start])>[forms]![frmtsall]![txtfrom] And ([SMDR In Order].[Call start])<[forms]![frmtsall]![txtto]))
GROUP BY [SMDR In Order].Party1Name, Names.Department, [SMDR In Order].Is_Internal
HAVING (((Names.Department)="ts") AND (([SMDR In Order].Is_Internal)="0"))
ORDER BY Format(Sum(TimeValue([Call duration])),"hh:nn:ss") DESC;

When i run it i am getting this error.

"Function is not available in expressions in query expression 'Format(Sum(TimeValue([Call duration])),"hh:nn:ss")'"

This works on my PC but not on the others that are same versions. Does anyone have any ideas??
Thanks

Glen

 

[PHV]

You may check the references on the other PC:
when in VBE (Alt+F11) menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GlenLynam]

Mate your a legend they were missing the chart component which i downoaded (mschrt20.cab) and installed all is good.
Thanks

Glen