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

    create vlookup to exclude list of numbers from certain date forward

    This is excellent! Thanks!
  2. 2Plan

    create vlookup to exclude list of numbers from certain date forward

    Trying to be more clear: I need to query the above data set, while excluding certain sequences that were badlisted on a specific date. In other words if the sequence number was badlisted on 9/13/10 then that sequence number would appear in the data set up until 9/13/10, but not after that...
  3. 2Plan

    create vlookup to exclude list of numbers from certain date forward

    How do import the 'ts' (timestamp field above) as a date. Currently, I have to import 'ts' as a text field, but I want to import as a date field. Thanks, for any assistance
  4. 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...
  5. 2Plan

    split or extract numeric characters from column

    The formula is even better! Thanks!
  6. 2Plan

    split or extract numeric characters from column

    figured it out. text to column (delimter "-") Thanks.
  7. 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...
  8. 2Plan

    Count a field and Count Unique occurrence of field

    Just curious, how many rows can we export to excel 2007?
  9. 2Plan

    Count a field and Count Unique occurrence of field

    You guys are great! Thanks for all the info!
  10. 2Plan

    Count a field and Count Unique occurrence of field

    Thanks Randy, Were upgrading to Excel 2007 next month!
  11. 2Plan

    Count a field and Count Unique occurrence of field

    Correct MajP. I just did a test. So if I import the dataset into an access table what simple query would give total seq count and total unique seq count at the same time?
  12. 2Plan

    Count a field and Count Unique occurrence of field

    Randy, Can I move a 200,000 line dataset into an Access table? Thanks. 2plan
  13. 2Plan

    Count a field and Count Unique occurrence of field

    Sorry for the confusion: I've listed the column headers. I need total count of seq column. According to the dataset below, Output "results.txt" file should read: Total Seq Count = 19 Total Unique Seq = 5 ts,loc_n,bus,route,ttp,grp,des,seq,tpbc '2010-07-28...
  14. 2Plan

    Count a field and Count Unique occurrence of field

    I would the output/results to go to a *.txt file. For example the output/results file would read: Total Riders = 192,000 Unique Riders = 3,100
  15. 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...
  16. 2Plan

    Multiple IIf function in design view

    Nice! Thanks.
  17. 2Plan

    Multiple IIf function in design view

    What would the syntax of the Switch function look like with a couple of block names in the example below? DivAbr: IIf([BLOCKNAME]="640-10","UTFRI",[DIVISIONABBR]) Thanks.
  18. 2Plan

    Multiple IIf function in design view

    This was very helpful! Thanks.
  19. 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...
  20. 2Plan

    bcp command from SSMS not working

    Thanks. The script worked, but results were output to bottom screen of SSMS, but not the text file. Can someone explain why?

Part and Inventory Search

Back
Top