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

  1. TomBorcoman

    Working with date ranges

    Thank you, aptly named focwizard! It did exactly what you said it would do....
  2. TomBorcoman

    Working with date ranges

    Hello, I have a table that looks like this: NAME DATE HOURS Smith 2/4/2004 4 Smith 2/9/2004 2 Smith 5/8/2004 1 Smith 7/1/2004 1 Smith 11/5/2004 5 Johnson 1/2/2003 2 Johnson 4/1/2003 1 Johnson 5/12/2003 6 What I'd like to do is have a running...
  3. TomBorcoman

    Change icon in Focus drilldown report

    Hi..I was wondering if you can change the icon that comes up in a Focus drilldown report. It has a bunch of magnifying glasses and we would like to change them to 'hands' instead...can this be done???
  4. TomBorcoman

    Consolidating records in hold file

    Guess I should have just tried it before responding! That worked focwizard...many thanks!
  5. TomBorcoman

    Consolidating records in hold file

    I think that will work to give me one record for each person but would that let me create those additional fields - Fund2, Dept2, Alloc%2 that correspond to an individual record?
  6. TomBorcoman

    Consolidating records in hold file

    Hi..I have created a HOLD file that was created with 2 joins and the data is what I want, however, I have some records that are listed twice and I want to combine the 2nd or 3rd, etc. instances into one line in a new table. Here is the example: Name ID Fund Dept Alloc% Ehlo 3...
  7. TomBorcoman

    Time format in Focus

    I know I should know this but where would be a good place to get information about subroutine HSETPT????
  8. TomBorcoman

    Time format in Focus

    We have data in the following format: 0953 = 9:53 am 1325 = 1:25 pm What is the easiest way to convert to a time format? The closest we got has everything but the colon in the proper spot.
  9. TomBorcoman

    Problems selecting data

    Thanks kiddpete! You're answer worked!!
  10. TomBorcoman

    Problems selecting data

    Hi there, first post for me. Below I have some sample data in a master file for employees and I would like some help with some code that will select/filter out the right data: ID# POS# FUND PERCENT EFF.DATE 4366 Z1 20502 100 35796 4366 Z1 20502...

Part and Inventory Search

Back
Top