Search results for query: *

SkipVought, you are correct. I apologize for not posting things in the correct way. dhookom, I tried what you suggested and... Thank you!!! that is what I intented to acomplish. I really appreciate all the help.

what I was trying to accomplis is to do a crosstab query with two values.

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...

Thank you vicvirk and thank you gmmastros. I was able to get what I was trying to accomplish. my code was correct. the only thing is that I forgot I was not working in the actual webserver. so I added the dsn to the server and voila. Sorry rookie mistake!!!

I created the same file structure and fields in my db2, so my thinking was, if I change the dsn-less to dsn I showld be able to use the same code

yes, I understand and agree. There are some instances when dsn-less has not worked out well with another db that I use, this db is in an AS400 box, ibm db2. In this case the dsn has worked out better

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 =...