Search results

Perfect, thanks for this! Exactly what I was looking for. :)

Is this kind of IF statement possible in excel? I need it to do the following: If A1 = "No" then do this formula, but If A1 = "Yes" then do this formula. I am unsure how to proceed with this, it is my first if statement in excel!

Exactly what I was looking for! Thanks! :D

Hello, I cant figure this one out, its probably really simple too.. :mad: I want this: SQLQUOTES = "SELECT SUM(Value) as QuoSum FROM Jobs WHERE Active='True' OR Active='False'" ... to only return results where QuoteDate = this year only, 2010. I would also like to know how to return for this...

Please help me! I have been trying this forever and I cant make it work. I am new at sql and everything. I just want to connect to my sql in asp. I have looked everywhere and even bought a book but It just will not work. I have tried hundreds of combinations because there seems to be a million...

Thanks PNGbill, maybe I will add this in the future.

:confused: I just have no idea how to apply this to my situation. Ill just stick with the input box because I dont know how to do this.

Its a stored procedure. What you said about having the reference to the form control on the button, how would this be done? We do use a button to activate the store procedure query, which generates an input box.

Hey! I have a stored procedure on my DB, a query with the following where clause: WHERE (Job = @Job) This asks the user for a job number... but how can I simply use the value of [Job] for the record that is being viewed?

In my case the value is from an input box, which is verified before the MkDir line plays out.

Solved! For people searching, this will work: MkDir ("C:\" & Job.Value)

Hey all, we have a command button called [activate] which goes through a number of processes, asks for some values, sets some fields to true etc... I am wonder if it is possible for me to add the creation of a folder to these processes. Lets say I want to create a folder using [Job] as the...

How can I achieve this? I want to: Sum the [Value] field, where [Active] field is True, OR where the [Invoiced] field is True. Here is my code so far, which is returning #Error =DSum("[Value]","Jobs","[Active]=1" AND "[Invoiced]=1") It works fine for one criteria, such as...

Hey guys, I am creating an adp on sql. One of my old queries doesnt work in the new adp. The criteria is >=Date() And <=Date()+15 which finds all the jobs due within 2 weeks of todays date from our DueDate field. Anyone have any idea what the new syntax would look like?

Thanks SQLHELL. Works good. Is there anyway of getting rid of the <DEFAULT> and <NULL> dropdown in the input box?

Little update. I have managed (I think) to create a store procedure, and created a command button to run it. It works this way: SELECT Job FROM Materials WHERE Job = '4444' But now I want to make it throw an input box. This does not work: SELECT Job FROM Materials WHERE Job = @Job

Its an adp running on sqlexpress 2005. I just want to have a button on a form that when pressed will query a certain table with the parameters the user enters, which will be a 4 digit number. That number wont be used for anything other than returning the appropriate records. Do you create a...

thanks for the post! this looks promising. i dont have any knowledge on creating stored procedure or where to start.. any links or info you can provide would be helpful to get me started?

Thanks I have changed the field to QuoteDate instead. Which "date" specify the field now? I can see why it should not be "date" now... Is this correct? [CODE]=DSum("[Value]","Jobs","