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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
problem with sum(case
Hello, I am trying to do a sum(case statement but not sure if I am going the right way about it This is what my sql statement looks like I ge a syntax error in the first sum(case select [Sales Jan 2007 Through Oct 2009].FEKNNB, [Sales Jan 2007 Through Oct 2009].FEAAC3, [Sales Jan 2007 Through...- edvil
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
convert dsn-less to dsn
Hi I have an asp page that connects to my access db. I would like to use a dsn connection but I am running into a couple of problems this is my original connection Username = Request.Form("txtUsername") Password = Request.Form("txtPassword") 'Build connection with database set conn =...- edvil
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
