Click here to Skip to main content
12,454,965 members (54,435 online)
Click here to Skip to main content

Tagged as

Stats

1.2K views
Posted

Type mismatch in expression. in access database

, 18 Jan 2013 CPOL
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,...

Revisions


  

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

License

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

Share

About the Author

Shambhoo kumar
Software Developer (Senior) East Vision Information System
United Arab Emirates United Arab Emirates
No Biography provided

You may also be interested in...

Pro
Pro
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160826.1 | Last Updated 19 Jan 2013
Article Copyright 2013 by Shambhoo kumar
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid