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 gkittelson 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. cmarshal

    Testing for List of Text Strings in Database Field

    Thanks, David! Where do I enter the stringvar array numbers_to_test := ['603555','605988','708333','99999'.............]; ?? Is this a parameter, formula, or part of the select formula itself? Also, I'm really trying to test the opposite way -- to seek if any of the array items are in the...
  2. cmarshal

    Testing for List of Text Strings in Database Field

    Working with data from our telephone system, I am tring to select records where any one of several telephone exchanges is included in the Dialed Number. I have gotten the formula to work where I enter a single area code and exchange combination as a parameter (ie: 603555) using the following...
  3. cmarshal

    Adding 5 Minutes to Time

    Hi Ken: Here's an example of the time field: DateTime (2001, 1, 11, 15, 23, 6) This would be 3:23 and six seconds pm today, January 11. I'm trying to identify all records with a time between 3:18 and 3:28, today. Thanks! -clint
  4. cmarshal

    Adding 5 Minutes to Time

    I'm trying to run a query that finds all phone calls within 5 minutes before or after a time that's entered as a parameter. How do I create "start_time" and "end_time" values by adding and subtracting 5 minutes to the entered time? What do the formulas look like...

Part and Inventory Search

Back
Top