Search results

You're right about that. Funny thing is I know how to solve the problem is SQL Server by using CAST instead of CDbl. I wasted a few hours trying to figure out why I could not get CAST to work. Only then did I realize that I was using CAST in an ACCESS query...thinking I was in SQL Server. It...

FDCUSA - Thank you for pointing me in the right direction. Once I started using CDbl I was on the right track, BUT the second issue was indeed the NULL problem. Bad table data!. There should have been no NULL values in File Received Date. Once I eliminated the bad data the code worked...

FDCUSA Thank you. Sorry I overlooked that question. I apologize as I will not do the math here either, but only because I closed in on a solution that touches on what you commented about NULL.:o DAY: Avg(CDbl([A LYDIAN DATA].[File received Date])-CDbl([A ENCOMPASS DATA].[File Started]))...

Thank you. It seems to be more than the commas. The one below has all the commas and does not work. Worked fine before migrating to SQL. SELECT [A ENCOMPASS DATA].Branch, Avg((([A LYDIAN DATA].[File received Date])-([A ENCOMPASS DATA].[File Started]))) AS [Avg Days From Lead To Loan] FROM...

I have searched and searched for the answer and I am certain it has been asked many times before. Unfortunately I cannot find it here and the answers I found doing a web search were not comprehensible to me due to my inexperience. I have a fairly robust database in Access 07. I recently...