Search results

I have re-worked my code and have it working now. To Galaxiom - using the CDbl function was helpful to force back to number - thanks

Hi folks, What I am working with is not an application, it's just a query I put together to process data I get sent to me via Excel. It's a lot of fields, and currently don't have the time to make up enough data (I do understand that part as I was a mainframe programmer for many years and...

Thanks for response, To Galaxiom - The Amt you are questioning is actually another table name, but I removed the table name because it is the abbreviated company for privacy. To JBH - sorry can not supply any data due to the fact that company I work for is goveren by HIPPA rules so that...

Hi Galaxiom, What I did is correct for what I am doing. I need to know why is the problem happening with the Nz function as I have explained it. Thanks Kenny

Hi all, Hoping someone can explain why I am getting an error with the Nz function in Access 2002. The code below is the same for each example, just showing the different samples (sorry for all the code). Each line is a subquery and the same, the only difference is the change of the date. There...