Search results

I found the problem.. The variables are declared as currency but they retrieve values from database that are stored as double and they are converted into double as well. I casted to currency and now the result is ok

yes they are declared as currency

Hi, I am writing a small program in vba for ms access. I need to write the following comparison but don't understand why it returns wrong result. I am writing following line of code. All variables are currency type. The result should be 0 because the subtraction should give 0 as a result...

Hi, I am new to access and I am having a hard time to understand how to execute a transaction from access. When I execute below code , obviously it will fail on the first run of the loop because sql syntax is not appropriate for sql server. But instead , it continues to run and passes to the...