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

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

    Need help with a Group Sort formula

    Hello, Need help adding a sort order to a group header. Currently the group header is set to Temp.Order.Header.Number. I need to keep this in place while also adding a sort by description.
  2. Jlok

    Query?

    I have a table for UPS tracking numbers and could possibly contain 2 or more entries with the same tracking number. Is it possible to write a query that would only show the first instance? I use this field on a crystal form and if it contains multiple tracking numbers it screws up the form. Thanks!
  3. Jlok

    TRUNCATE?

    Trying to use truncate to return a whole number... TRUNCATE ({field}) What am I doing wrong? Table contains order values. All entries have a 2 place decimal 123.45 I want to return 123?? What am I missing? Thanks-
  4. Jlok

    Form Comes up Blank

    Just upgraded our accounting software and the new version is using crystal 10. Old edition used crystal 8. Anyway if some of the fields are empty the invoice just prints blank. What am I missing? I tried to suppress without it helping. I eliminate those fields that dont show on every invoice and...
  5. Jlok

    Database Driven Drop-Down menu

    Want to create a database query based on dynamically driven drop-down menus. Query is not the problem, problem is dynamically creating the drop-downs. Access is database source. Using Frontpage I can create the three drop-downs, but cannot have them change without hitting submit. I think I need...
  6. Jlok

    HTML GENERATION

    Hello, Working on a website and have to generate about 15,000 extended product descriptions. Most products have similar characteristics. Wondering if anybody has any idea of some kind of a text-input to html output form or something to speed this up. Maybe a GUI so people not "HTML...
  7. Jlok

    Trailing Zeros....

    Here's the formula.. If {PACKINGSLIP_HEADER.S_TERMS} = "NET 30 DAYS" then IDAutomationFontEncoderCode128 ({PACKINGSLIP_HEADER.S_ORDER_NO} & {@upstotal} , 0) else IDAutomationFontEncoderCode128 ({PACKINGSLIP_HEADER.S_ORDER_NO} , 0) Problem is with @upstotal field, I need this to be a...
  8. Jlok

    HELP WITH QUERY SELECTION

    I am using a query to retrieve data from a btrieve dbase. The table I'm using has multiple lines of the same entry. How would I select just the first one? Example: 1 1 1 1 1 2 2 2 2 I need to just get the first first entry of all the different entrys.. 1,2 and so on

Part and Inventory Search

Back
Top