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

  1. CTLReporting

    formating with commas

    Hi all, I have a problem. I have converted a number into a string in a formula. But when converted to a string it adds commas aftert thousands. If the number was 1005 my formula is supposed to say 1005/2 but instead it ends up saying 1,005/2 and when scanned by a barcode scanner it messes...
  2. CTLReporting

    Duplicate Records

    How do I create a report that will show me all of the records in which every field is the same in a table EXCEPT for the key. Here is some dummy info key field1 field2 field 3 field 4 ........... x y yy yyy T x1 y yy yyy...
  3. CTLReporting

    Exceptions Report

    Hi all, I am making a report that prints the records in one table that do not have an associated table in another table. Does anyone have any idea how to do this? Table1 has 6 fiels in common with Table2. I think this would be easy in the way that I link these two tables. I don't care what...
  4. CTLReporting

    WhilePrinting & WhileReading

    Could someone please explain these two? And the advantage they have over just using forumlas rather than defining when they run during the report? I know WhilePrintingRecords runs AFTER the database read, and WhileReadingRecords runs BEFORE the printing of data. If I am wrong with this...
  5. CTLReporting

    Suppressing a Group

    To all: Is there a way to suppress a group header if there is only one group? I want the Group Header to show if there is more than one group, but if not, I don't want it to show the header for just one group. Any input would be helpful. Thank you, CTL Reports Group, Running...
  6. CTLReporting

    Changing table names

    I am a Crystal report writer, and I imported a database into access because access is working easier than my current database right now, because of some software issues. My problem: When I import to access 2000, access adds a prefix to the table names. Where my table name is sample it would...

Part and Inventory Search

Back
Top