Click here to Skip to main content
13,198,075 members (81,150 online)
Click here to Skip to main content

Tagged as


Posted 18 Jan 2013

Type mismatch in expression. in access database

, 18 Jan 2013
cmdselect.CommandText = "SELECT PD.Prod_ID, PD.Prod_BrandName, PD.Prod_ModelNo, SUM(iif(Isnull(PM.Prod_Qty), 0, PM.Prod_Qty)) AS Purchase_Item, SUM(iif(Isnull(SM.Prod_Qty), 0, SM.Prod_Qty)) AS Sale_Item, SUM(iif(Isnull(PM.Prod_Qty), 0, PM.Prod_Qty)) - SUM(iif(Isnull(SM.Prod_Qty), 0,...



Compare Revision Minor Date Status Editor
2 - publicly available No 18-Jan-13 21:03 Available Shambhoo kumar
Updates in content. 63 changes had been made.
1 No 18-Jan-13 20:58 Available Shambhoo kumar


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Shambhoo kumar
Software Developer (Senior) East Vision Information System
India India
I love software development, It's my foremost passion in life. When I’m not at work, I’m tinkering, learning about new technologies, ways to solve problems, better techniques, tools and algorithms.

My goal is to find a truly collaborative environment filled with people who love to create and love to learn. Where I can work with a team to develop and fulfill business needs, where we can create solutions for people that not only fit their needs, but exceed their expectations and go beyond what was believed possible.

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.171020.1 | Last Updated 19 Jan 2013
Article Copyright 2013 by Shambhoo kumar
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid