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

    create vlookup to exclude list of numbers from certain date forward

    How can I create a vLookup table to exclude a list of numbers (i.e., the seq column in data set) from a certain date forward from the data set below (data set will be from Sep thru Nov)? I will import the data set below into an access DB first. ts,loc_n,bus,route,ttp,grp,des,seq,tpbc...
  2. 2Plan

    split or extract numeric characters from column

    Is there a way I can get just the numbers of this column in a separate column by itself, so I can sort the data? 1-NORTH LAMAR/SOUTH CONGRESS 10-SOUTH 1ST/RED RIVER 17-CESAR CHAVEZ 2-ROSEWOOD 20-MANOR RD/RIVERSIDE 201-SOUTHPARK MEADOWS 21-EXPOSITION 22-CHICON 3-BURNET/MANCHACA 30-BARTON CREEK...
  3. 2Plan

    Count a field and Count Unique occurrence of field

    How can I count the next to last column of the dataset below and count the unique occurrence of the next to last column of the dataset below? Typical dataset is about 200,000 lines; so I would have to use a command to open the ascii file and then count. '2010-07-28...
  4. 2Plan

    Multiple IIf function in design view

    I would like to create a make-table that uses a multiple IIf function similar to the statement below: DivAbr: IIf([BLOCKNAME]="640-10","UTFRI",[DIVISIONABBR]) Based on the 8 different [BLOCKNAME], I want the [DIVISIONABBR] to say "UTFRI". It works for one condition, but not for several...
  5. 2Plan

    bcp command from SSMS not working

    The following bcp command from SSMS is not working. Can someone explain why? I've attached error message below also. Thanks. declare @sql_varchar(8000) select @sql = 'bcp master..sysobjects out c:\bcp\sysobjects.txt -c -t -T -S' + @@servername exec master..xp_cmdshell @sql Msg 102...
  6. 2Plan

    How to export data from SQL Server Management Studio to Text File

    I will only have access (possibly only read-only access and ability to export) to the SQL Server 2005 Management Studio or the SQLCMD utility to export the data to a "fixed width" text file. Is there a script or Transact-SQL code that I can run in the SQL Server 2005 Management Studio or the...
  7. 2Plan

    How to export query data from MS SQL Server to text file

    Need to export the MS SQL Server query data to the (fixed)text format below. (e.g. columns/rows must appear in fixed format) Rout Block_ _Date_ D Bus_ D Trip Time_ On_ Off 392 392001 102008 1 7036 6 0451 25.0 2 0 392 392001 102008 1 7036 0 0516 28.0 7 8 392 392001 102008 1 7036 1...
  8. 2Plan

    Trying to replace values in column B with values from column I

    I'm trying to replace values in Column B with Values from Column I. Can someone help me debug the code below? Sub Edit_APC_Data() For Each c In Worksheets("Sheet1").Range("B2:B14786").Cells Select Case Range("I2:I14786").Value Case "UTFIN" Range(c).Value =...
  9. 2Plan

    Select Case Statement in the SQL "Add Command" tool

    Does Crystal Reports "Add Command" utility allow you write Case statements. Can anyone tell me how I can format the Query below into an equivalent query in Crystal Reports, using the "Add Command" utility? Or the Formula tool or the SQL Expression tool? Thanks in advance for any assistance...
  10. 2Plan

    Split text field into date and time field

    How can I split this text field into two fields (date & time) 2007-10-05 09:09:15.000
  11. 2Plan

    Convert Time format to decimal format

    Does anyone know how to convert Time format to decimal format? Is there an easy to convert 42h51 to 42.85?
  12. 2Plan

    convert date to text in MS Excel

    Is there an easy way to convert this date '8/15/2007' to '081507'? The dates are MS Excel.
  13. 2Plan

    Export MS Access Table to Fixed Width Text File

    I would like to export a MS Access Table to Fixed Width Text File. I would like to use VBA script to set the start/end of field and the width of the field. Does anyone know a simple way to do this? Thanks for any help.
  14. 2Plan

    IIf statement in query design grid

    How can I write this query in the "MS Access Query Design Grid" IIf DepartDiff > 330 place "Late" in field IIf DepartDiff < -30 place "Early" in field Else place "On-Time" in field Here's a copy of what I have so far: SELECT [0601sa].A_Time...
  15. 2Plan

    Convert Time values after midnight to 24:00, 25:00, 26:00

    I would like to run a query that changes the value "00:02" to "24:02" and "01:04" to "25:04" These values have a text data type. "00:02" represents 12:02AM "01:04" represents 1:04AM Thanks, for any assistance.
  16. 2Plan

    How many records/rows can a MS Access 2000 DB hold

    How many records/rows can a MS Access 2000 DB hold?
  17. 2Plan

    Remove leading zeros and dash from string

    I would like to create a new table from Table1 Table1 consist of one field: OldField 300-06 982-35 001-12 030-04 I would like to use the make-table in query-grid to create Table2 consisting of three fields: OldField NewField1 NewField2 300-06 30006 300 982-35 98235 982 001-12 112 1...
  18. 2Plan

    Concatenate Fields withing SQL Select Clause

    How can I concatenate CommProjCode with UniqProjCode as FilePlanCode? sql = "SELECT MasterProjectCodes.CommProjCode \& '-' \& CommonProjectCodes.UniqProjCode As FilePlanCode, " & _ " INTO Temp FROM CommonProjectCodes INNER JOIN MasterProjectCodes ON " & _...
  19. 2Plan

    update two columns

    I'm trying to update two columns but I get a syntax error. Can someone tell me what's wrong with this syntax? What's the syntax to update two columns? Thanks. DoCmd.RunSQL "UPDATE MasterProjectCodes SET (UniqProjCode, UniqProjName) = (3000, 'APC')" _ & " WHERE CommProjCode='320-301' And...

Part and Inventory Search

Back
Top