Coul Not Execute SQL Statement

[jamphan]

I am receiving an error message (...could not execute SQL statement...)when I try to run a report with an average of a field. I have a query that calculates turnaround time between 2 dates using the DateDiff function. My query runs fine and the report runs fine as well. I am trying to get an overall average of the turnaround time but when I include that field in the Report Footer section I get the error message. I have many other reports that perform the same average and run fine. Any solution to this problem???

 

[Crilen007]

Hmmm...

Try making another of the same report. Keep the one you have, and create a new one from scratch, just don't go through all the trouble of making it pretty, and see if that works.

 

[jamphan]

Tried it and still doesn't work. Something is up with the Avg formula that it doesn't like. I have banged my head around too much on this one. If the turnaround time is on the report there should not be a problem averaging it right? i have done this countless times without any problems.

 

[jamphan]

I have figured out the problem. I have the turnaround time in my query formula linked to a module and did not have one of the fields defined to make it a number. Thanks anyway.

 

[Crilen007]

Heh, kinda funny. I was originally going to reply with "check for typos".