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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Starlitnight
  • Order by date
  1. Starlitnight

    SQL Can I update a table via an array:

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

    SQL Can I update a table via an array:

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

    SQL can I update a table with an array?

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

    Hopefully an Easy one. Less Than symbol NOT recognized as a field

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

    Hopefully an Easy one. Less Than symbol NOT recognized as a field

    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?
  6. Starlitnight

    How do I get a submit button to send web form inot?

    Thank you very much for the help!!!
  7. Starlitnight

    How do I get a submit button to send web form inot?

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

    If statem to search for special charecter

    YES! That worked! Thank YOU!
  9. Starlitnight

    If statem to search for special charecter

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

    How do I get a submit button to display results in Word?

    Thank you, That is VERY helpful. :)
  11. Starlitnight

    How do I get a submit button to display results in Word?

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

    excel 2003 deleting group of defined names

    Thank you so much! I appreciate the help!
  13. Starlitnight

    excel 2003 deleting group of defined names

    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!
  14. Starlitnight

    excel 2003 deleting group of defined names

    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".
  15. Starlitnight

    Can CInt() be summed?

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

    Can CInt() be summed?

    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..?
  17. Starlitnight

    Can CInt() be summed?

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

    Can CInt() be summed?

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

    Can CInt() be summed?

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

    Can CInt() be summed?

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

Part and Inventory Search

Back
Top