Search results

that didnt work. if i put xxx in a cell, it still counted them as 1, where i want it it to count all 3 of the x's thanks

Hello i have an excell sheet where the user enters in an 'x' in a cell and at the bottom of hte sheet it counts up the 'x' entered. here is my formula. =COUNTIF(F6:F74,"x") my question is, how would i do it if the user wanted to enter multipe 'x' into the cell and still count multiple 'x'...

Yes i understand that. here is my where clause and it works if its run at 7AM everyday, but if its run at 10am then i only get data from 10-10. but i always want data from 7-7 where a.efnsent >= DATEADD(Day, -11,Getdate())

meant forget it on the date only. just 1 date, but 2 times

In simple terms. forget the between. say i have a parameter 9/10/12(today) i would want data from yesterday at 7:01AM through today at 7:00AM

ITs date/time, but when i end up using the date part as a parameter how would i do it then. Ultimately heres what i would want it to be Where date Between @StartDate and @Enddate my startdate would be 9-10-12 and enddate would be 9-11-12 but i would want data from yesterday at 7:01AM...

I need to be able to query results from my table from yesterday at 7:01AM through today at 7:00AM. basically a full says worth of data. im not having any luck doing that. Any help would be great

I have a table that has a field called jobcode In this field it could have the same job code for example MKRLF. There could be mulitple records in this table for MKRLF. THis table also has a field called EFFDate, and what i want to do is always get the jobcode field that is the most recent...

Those 2 columns are directly tied to column 1. i can retrive the value just fine, but im struggling on how to put it all together and get the value i want either 1-10 from my query into a txtbox in my vb code

Heres my scenario: i have a textbox with a point value for example is 225: I have a table that looks like the table below. What i want to have is to beable to look at the textbox that has 225 value in it and look at the range in the table below and have the 1st column values 1-10 to show up in a...

I have a user who has Windows 7, and used Word 2010. When she types an outline or uses the bullets and numbering feature, Word wont auto inddent for her. any help would be great. Thanks

i was able to figure this out, i dont have any explanation on why it woudlnt run faster on the new 2008 server, but i had another view that this view was pointing too, and it had a > 1 on a field in a where clasue, so i changed it in the select statement to a MAX

I have no indexes and i didnt have any before either on my sql 2005 server. i can take out the group by and order by and it still takes 2:50 to execute.

im not sure how to do that, can you tell me? what would change in sql versions that would slow this down in sql 2008?

Below is my query. We did a recent upgraded from SQL 05 to 08 and before this query would run in about 7-8 seconds on sql 2005, now in 2008 it takes well over 3 minutes to complete. any ideas why or what i can do? select receiptdate, lotnumber, receiptquantity, palletcode...

I have a field in my query that are like this 1 2 3 4 5 6 7 8 9 10 11 ect, but i want to know if there is away to make a field 2 digits so that my sigle digits will be 01,02,03, ect and then 10 11, 12 will stay the same?

Here is my code, and i also attached the picture of the error im getting with this code. Protected Sub btnsubmit2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsubmit2.Click Dim intinjnumber As String Dim intEmpID As String Dim dtInjDate As Date Dim dtInjTime As Date...

what do you put in where there are ?'s??

this is what i get when i do that, i had tried that previously... strcommand = "Insert into Injury(injnmbr, empID, injdate, injtime,osha) values strcommand = "Insert into Injury(injnmbr, empID, injdate, injtime,osha) values ( '" + intinjNumber + ",'" + strEmpID + "','" + dtInjDate + "','" +...

heres what i have tried and it errors out, im thinking my syntax is off...any help? I dummyed down the statement to a couple fields so that i can test. strcommand = "Insert into Injury(injnmbr, empID, injdate, injtime,osha) values intinjNumber + ( '" + strEmpID + "','" + dtInjDate +...