Search results for query: *

Thank you for your time and explaining this to me! Thank for giving the work-around for it through a temp table, I am grateful.

Bascially I want to UPDATE a particular column Essentially I want to do the following: ALTER PROCEDURE WriteStockStatus (@asin varchar(10), @asinStockStatus varchar(15)) AS UPDATE OnSale SET StockStatus=@asinStockStatus WHERE ASIN=@asin Ok, but, I don’t want to have to call...

Bascially I want to UPDATE a particular column Essentially I want to do the following: ALTER PROCEDURE WriteStockStatus (@asin varchar(10), @asinStockStatus varchar(15)) AS UPDATE OnSale SET StockStatus=@asinStockStatus WHERE ASIN=@asin Ok, but, I don’t want to have to call...

=if(or(<Field1>=0,<Field1>="",<Field1><0.005),"TEXT","text2")

Hi, I have an issue while trying to put in a formula... all I need is for it to check if a field is < 0.0005 ...The problem I'm having is that Excel is reading the < as value rather than the less than symbol. Any ideas on how to fix this?

Thank you very much for the help!!!

I'm trying to write code for when the submit button is clicked and everything is filled in correctly, the filled out form will be sent to my job as an attachment. Do you have any idea how to do this? I'm using the ASP server side language.

YES! That worked! Thank YOU!

Hi, I would like to know how to create a formula that would search for an asterisk *. If I write: =IF(ISNUMBER(SEARCH(""*"",A1)),"<myfield>","") Excel treats the * as a special charecter is there any way around this? Thanks

Thank you, That is VERY helpful. :)

Hi, I have created a “submit” button on a form. When the button is clicked, I want the results to appear in a word document. Can I make this happen? If so, how? The form results display names for labels.

Thank you so much! I appreciate the help!

Hi John, thanks for the post! The only problem is that there are defined name I actually do want to keep. I was hoping for a something such as "if defined name = "act"&"*" but guess I'm not that lucky....I knew I should've been a drummer!

Hello, Is there a fast way to delete defined names in an excel worksheet? I'd rather not go line by line in the defined name dialog box. Is there another way I can delete groups of defined names? They all start with "act".

Thank you! I looked up nz on the internet and your definitions and examples are much more clear. Thank you again.

Hello! I've not tried CLNG or NZ out as yet but am grateful to know other functions that can achieve the sum. I realize that Clng would be for a long integer but what is nz if you don't mind my asking..?

GOT IT! There was a flaw in the data itself not the syntax! Pete, thank you for your time.

Thanks again Pete... Here is the complete query in which my report is based: SELECT tFolder.vcFolderType, tFolder.vcFirstName, tFolder.vcLastName, tFolder.vcOrganization, tAddress.vcAddress1, tAddress.vcAddress2, tAddress.vcCity, tAddress.vcState, tAddress.vcCounty, tCalls.dtCalled...

Thanks for the response Pete.. Good catch! Here is how I've extracted the number portion of #Served:23 NumberServed: Mid([vcResults],InStr([vcResults],":")+1) I then used the Cint function to convert the remaining text of 23 to an integer like this: TrueNumberServed: CInt([NumberServed]) I...

Hi, I have a query which pulls the number of people we serve by converting text to a integer via Cint(). The original value was #Served:23. The numbers after the colon were extracted and converted via the Cint() function. Now I am to create a report that contains a sum of that field. Here is...