Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Text Box input mask
i need to put a input mask on a text feild can any one help?- bruce55
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
Access to SQL
i managed to get the case bit in it was the HAVING (((Sum(IIf([AdjInd]=2,-[ExVat],[ExVat])))<>0)) i couldnt word right ? i wasnt sure about the brackets- bruce55
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Access to SQL
I am trying to convert a Access Qry to SQL could anyone help? SELECT QryAdjCostEXVat.OrderNo, Sum(IIf([AdjInd]=2,-[ExVat],[ExVat])) AS Val FROM QryAdjCostEXVat GROUP BY QryAdjCostEXVat.OrderNo HAVING (((Sum(IIf([AdjInd]=2,-[ExVat],[ExVat])))<>0))- bruce55
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
