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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How Do I add A Column To Count SSN
Well as it worked out I did not need any query more complicated than select * from loggedcalls where suspious = "Yes" I did this by evaluating each call as it came in and checking whether it meet the criteria as a suspious call. I was looking for a work around for the complicated sql I was not... -
How Do I add A Column To Count SSN
LKBrwnDBA I tried doing as you said but I get the error dataAdapter.Fill(_dataSet, "LoggedCalls") Run-time exception thrown : System.Data.OleDb.OleDbException - You tried to execute a query that does not include the specified expression 'SSN' as part of an aggregate function. How do I get rid... -
How Do I add A Column To Count SSN
I messed the above sql up when I was pasting it this is the one I was working with. SELECT DISTINCT SSN, Job_Dispatch_Date, First_Name, Last_Name, CID_Phone, CID_Name, Call_Start_Time, Password_Used, Call_Type FROM(LoggedCalls) WHERE instr( Call_Type,'Call') > 0 and ((( Job_Dispatch_Date) In... -
How Do I add A Column To Count SSN
I have a data set, That was set up using a vary complicated querry. I had quite a bit of help by a gentleman who was vary vary good as sql:-). Now I want to add a column that counts the number of identical [ssn] in each [ssn] group. In a sql it would look kind of like this "Select ...
