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 bkrike 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. turtlepatch

    Weekend Order Date Add Business Days for Due Date

    I need to determine the due date of an order. Orders come in between 18:00 of one day until 17:59 of the next day. Anything between 18:00 and 24:00 counts the next day as day 0. After 24:00 the current day is day zero. I need to show the due date (day 2). I have a formula from Ken Hamady...
  2. turtlepatch

    How to write a barcode that will read "Data Tab Data"

    I have two fields, JobID and SubJobID, that need to be populated. I want to be able to write a barcode that will put in the JobID, then a tab, and then the SubJobID, all in one line. Our scanners automatically put in an enter after reading the code. I am using Code 39. Thanks
  3. turtlepatch

    Display update date of a different file in excel.

    I am looking to display the update dates of several different excel files in one workbook. For example, I would like to display the date of books1.xls tools.xls jobs.xls all in excel file master.xls. A B book1 05/02/09 12:23:05 tools 05/01/09 11:35:45 jobs 05/15/09...
  4. turtlepatch

    Display update date of a different file in excel.

    I am looking to display the update dates of several different excel files in one workbook. For example, I would like to display the date of books1.xls tools.xls jobs.xls all in excel file master.xls. A B book1 05/02/09 12:23:05 tools 05/01/09 11:35:45 jobs 05/15/09...
  5. turtlepatch

    Missing number in a string sequence

    I have a problem similar to thread149-912093 except that my sequence of invoices are strings. Basically I have a list of InvoiceID's that are sequential, however, I need to identify the one's that have been deleted. For example... 10001 10002 10004 10005 10007 I need to be able to have the...
  6. turtlepatch

    Running Totals Previous record

    I am working in Crystal 9.2 with an ODBC database. I have data that displays Job-id's, Location-id's, and Date of location change. Each job will have several location id's and I am trying to count the number of jobs in each location at the time of the prompted date. For example: job-id...
  7. turtlepatch

    Crystal: Count a field only if another field has occured before it

    I am working in Crystal 9.2 with an ODBC database. I have data that displays Job-id's, Location-id's, and Date of location change. Each job will have several location id's and I am trying to count the number of jobs in each location at the time of the prompted date. For example: job-id...

Part and Inventory Search

Back
Top