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

  • Users: scootswiss
  • Content: Threads
  • Order by date
  1. scootswiss

    Select the best fitting carton

    I am working on a process to select the best fitting carton for our product line. I have a table of all items item with the length, width, height and cube for each item in separate fields. I also have a table of our possible shipping cartons with the L, W, H and inside cube in separate fields...
  2. scootswiss

    Accesss 2000 Db compacts, but does not repair

    I have an Access 2000 db that I have run the compact and repair tool on many times before. Today when using the tool in the bottom left of the monitor screen I can see it would run through compacting, but not repair. The status only completes 1/2 way and the word "compacting" stays...
  3. scootswiss

    Query a table for values in a second table of values

    I have a database with 2 tables and doing a study of certain products shipped. Table1 records are a line detail of SKU's shipped. For example if 1 item shipped then only column1 has data, but if 2 items shipped there is data in couumns 1 and 2. The data is the shipped SKU. Table2 is a SKU...
  4. scootswiss

    How do I Remove Hyphens from a FedEx number in Excel?

    Our company is mail order and receives updates from our drop shippers on orders filled. This information is in an Excel spreadsheet. One of the fields has the FedEx number formatted like this 0300-1290-0006-4640-9750. To upload this information to our mainframe system the field can not...
  5. scootswiss

    Converting a number to text, leading zeroes and no decimal

    ToText {FMSH_REQUISITION_DETAIL.COST_EA}, "000000.00000",5) Above is my formula to convert this Oracle cost field to text. It works, but our mainframe programmers need this field formatted without the decimal. How does this formula need to be written? The Oracle field is a...
  6. scootswiss

    Writing a formula to pad a text field

    I am compiling a report in Crystal 8.0, pulling data from an Oracle database. The flat file will be imported into a mainframe system. My question, is it possible to write a formula for a text field to always be 6 characters, even if the data is only 4 or 5 characters? In other words, use a...

Part and Inventory Search

Back
Top