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!

  • Congratulations Chris Miller 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. GLmill

    Only Data For First Record Shows Up???

    You could suppress the Blank sections. Place this in the formula field for the formatting of this group and check the suppress box. if {follow_up_intv_dt}=0 then true else false; At least then you can get rid of the blank lines. -TO
  2. GLmill

    Linking to specific database based on formula

    The problem is the tables are created daily. What I need to be able to do is reference a table that has not yet been created when the original report was written. I need to be able to write the report using standard data, however, at run time have it get records from a table that I can not add...
  3. GLmill

    Linking to specific database based on formula

    What I've got is a database that has hundreds of tables. These tables are created and named automatically inside the original database. I need to be able to link to them based on either a formula or a parameter field. Here is an example of what I need. I have a database called Jobrpt.mdb, inside...
  4. GLmill

    Multiple Numbers to one line of text

    I was able to get the distinct count of Number B's that I needed by using the following variation of the formula above in the details section: whileprintingrecords; stringvar MyNums; if instr(MyNums,totext({PRODUCTINFO.SequenceNo},0,"")) = 0 then MyNums :=...
  5. GLmill

    Multiple Numbers to one line of text

    The formula is working except I am not getting a distinct count. The result looks like this for the B field: 1, 1, 1
  6. GLmill

    Multiple Numbers to one line of text

    I have a report that contains records with a "Number A" and a "Number B". The Number A is what is used for Grouping. What I need to be able to do is list all the Number B's that are contained in the records of that group. Here is an example of what the records look like...

Part and Inventory Search

Back
Top