Recent content by bobleb

Thank you for your inputs, I will use it but first I need to understand what is exactly is wrong here.

Thank you Pat, I will give it a try and see if there is any improvement in the result. My point is again same why Access is behaving different is these 2 rows. Thanks.

Thanks for your inputs but as you see in my data there is no decimal values at all in the second row which is coming correctly while in the first row everything is fine with the decimal values. Rounding I am already aware of but dont want to use without understanding the real problem here. Thanks.

Hi Experts, I am facing very weird issue here. I have a simple mathematical calculation which is resulting in scientific values instead of simple 0. Please refer the diff column in the below query and result: Query " SELECT code_combination, YTD_ACCT_BAL, NAT_ACCT_YTD_BAL_SUM...