Results 1 to 3 of 3

Thread: count the total records for multiple tables

  1. Dec 15th, 2002, 03:57 PM #1
    nkad
    nkad is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2000
    Posts
    770

    Question count the total records for multiple tables

    How can I count the total records for multiple tables and display the results? When I try to create a calculated field i get the count of the first table but the second one always comes out as the same number as the first table.

    Any Ideas?
    Reply With Quote Reply With Quote
  2. Dec 17th, 2002, 01:14 AM #2
    buddu
    buddu is offline
    Hyperactive Member buddu's Avatar
    Join Date
    Jul 2001
    Location
    India
    Posts
    446
    with out having a link between two tables you cannot create a report in Crystal. So deff. it will display the count value of result set of the two tables.

    I think u cannot get two valus for two diff. tables.

    Cheers
    prasad
    Reply With Quote Reply With Quote
  3. Jan 16th, 2003, 10:59 AM #3
    barbourk
    barbourk is offline
    New Member
    Join Date
    Jan 2003
    Posts
    3
    Try using the recordcount property, assign it to a variable, add the two variables.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width