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 gkittelson 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: *

  1. rderkis

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

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

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

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

Part and Inventory Search

Back
Top