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 TouchToneTommy 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: JcTon
  • Content: Threads
  • Order by date
  1. JcTon

    Transfer data from Access to Excel

    Keep getting syntax error upon trying to run the following. Any clue as to what I am missing? Option Explicit Option Compare Database Private Sub TransferToExcel() On Error GoTo Err_TransferToExcel Dim query As String Dim file As String query = "qryFindAllEligDates" file =...
  2. JcTon

    T-SQL - Find Client Market Code and Plan Code at time of initial span

    Have a sql server database that stores information about clients such as the date/month that the client initial became a client (initial client span) and the MktCode and PlanCode for the clients. Sometimes the clients terminate service that is recorded in the field titled "ClientEndDt." If a...
  3. JcTon

    Convert Exponential Number to Non Exponential Number TSQL

    Familiar with using the following to convert dates within Sql Query Analyzer; convert(varchar,START_DT,110) SeriesStartDt Question - How do I convert a exponential number to a non-exponential number? Currently, when I run the query in SQL Query Analyzer and then import the results into...
  4. JcTon

    Change Field Names Using VBA

    Imported text file into Access table and field names did not import correctly. (Field names are in row 30!) Currently, field names are field1, field2, field3, etc. I assume that I can modify the code below to not only change the field names but also to specify the data type in the field. Is...
  5. JcTon

    SQL Query Analyzer - Multiple criteria in Where Clause

    Not obtaining the correct result set using the following in the WHERE clause in a SQL Query Analyzer query; Where client_id number between '124.5' and '130.5' or between '305' and '340.2' or between '409.1' and 415.25' In other words, some of the records in the result set shouldn't be there...
  6. JcTon

    Excel - DateDiff Formula Not Displaying Correctly

    Using the following formula to calculate the age; =DATEDIF(BirthDate,TODAY(),"y")&" years "&DATEDIF(BirthDate,TODAY(),"ym")&" months "&DATEDIF(BirthDate,TODAY(),"md")&" days" Sometimes, the result displayed in the cell location within Excel is "days." Any clue as to what is going on and how...
  7. JcTon

    TSQL - Query Not Extracting Data

    Not quite able to figure out the problem/resolution to the following query not extracting data. Query is designed to extract all current employees for the month-employees that do not have a eligible begin dt prior to the first day of the month. (Note, employees can have multiple elibility...
  8. JcTon

    Total Paid Amts Per Account Number

    Need to solve a problem. Have an Excel worksheet with the following columns; AccountNo-----PaidAmt 12463---------100 12463---------200 12463---------300 25466---------250 25466---------175 How can I sum up the total paid amount by Account No using a sumproduct formula? I am aware of using...

Part and Inventory Search

Back
Top