I Have 3 Queries in access 2 of them are being used as a calculator we willcalled them Cal1 and cal2. The third query The Order query displays the Customer , the orders and totals which consistes of cal1+cal2 (there is a possibilyty of some cells for cal1 or cal2 beinging blank) .
The results of all 3 queries are good.
My Issue is when I read the data from vb.net using oledbreader some of the cells in the total column are null when there is a value in cal1 and not cal2 (ex: 2+0=Null).
Bein 3 queries I did not post them but if you require the or just one of the let me know.
By the way all of my nimeric values are Decimal values.
Hope somw one can help Thanks
All 3 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.