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

    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...
  2. 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???
  3. 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...
  4. 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.
  5. 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