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 Wanet Telecoms Ltd 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. langgang

    Convert Numeric Object to Char Object

    I discovered the answer to my own question! By making an object that is a character and using the function format(<numeric field>) I get the character equivolent of the numeric value. By adding a right('00'+format(<fieldname>),2) I ensure I get two characters regardless of the size of the number.
  2. langgang

    Convert Numeric Object to Char Object

    Designing my universe I want to add an object which is the character equivolent of a numeric object. In the database it is a number, but I want to create a character object in my universe from it. How do I do that?
  3. langgang

    Latest test record for each well in table of well tests

    Thank you both for responding. Sri, your suggestion was exactly what I was looking for and it worked! Kudos!
  4. langgang

    Latest test record for each well in table of well tests

    I have a table containing the test date, well number, and test results fields. Whenever a well is tested a new record is added to the table. Some wells can be tested multiple times before others are tested at all. I want to list the latest single well test for each well and show the date of...
  5. langgang

    Latest test record for each well in table of well tests

    I need the information from the latest well test for each well in the database. The wells have multiple tests, and not in any order (one well may have 3 tests before another have 2 tests, so overall ranking doesnt' work). I have a well table and a well test table. Any ideas?

Part and Inventory Search

Back
Top