Alpha Video Training
Results 1 to 5 of 5

Thread: How do I create a table with totals from another

  1. #1
    Member Graham Wickens's Avatar
    Real Name
    Graham Wickens
    Join Date
    Apr 2000
    Location
    Gloucestershire, UK
    Posts
    795

    Default How do I create a table with totals from another

    I don't know where to start with this one, although I have created a report with the necessary details, but that does not allow me to then manipulate the resulting totals. [the report used calculated field = count(reg,grp->where) reg being just as a field to count, if that is any help with this].

    the problem:

    Table called "Logging" has the field relevant to this problem called "Where".

    For each different value of field Logging->where (where Logging->Where is not blank), I want to count the total number of records that have the same value of Logging->where and put the results into a new table to allow me manipulate the compiled data. for instance the results table to have a field called "Where" and a field called "Count".

    how do I go about doing this, cos I'm stumped.
    --
    Support your local Search and Rescue Unit, Get Lost!

    www.westrowops.co.uk

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default Re: How do I create a table with totals from another

    Do the Summarization options for a Crosstab operation include a simple count?

    Later:
    Yes, count is a summarization option so this ought to be just the ticket for you.

  3. #3
    Member Graham Wickens's Avatar
    Real Name
    Graham Wickens
    Join Date
    Apr 2000
    Location
    Gloucestershire, UK
    Posts
    795

    Default Re: How do I create a table with totals from another

    Ok,

    never used that before, so might be more questions on this

    thanks Tom.
    --
    Support your local Search and Rescue Unit, Get Lost!

    www.westrowops.co.uk

  4. #4
    Member Graham Wickens's Avatar
    Real Name
    Graham Wickens
    Join Date
    Apr 2000
    Location
    Gloucestershire, UK
    Posts
    795

    Default Re: How do I create a table with totals from another

    I've never even noticed that operation before!!

    seemed simple enough, but when I run it I get the following error:

    Error running Summarize Operation
    the system cannot find the file specified:
    d:\......\LocationTotals.ddx
    Where LocationTotals is the new table being created. Do I have to define the new table before I run the summarize?

    added later;

    created a table called LoggingTotals with fields Where and reg, re-ran the operation and it worked a treat.

    thanks Tom
    Last edited by Graham Wickens; 04-16-2007 at 04:27 PM. Reason: added detail
    --
    Support your local Search and Rescue Unit, Get Lost!

    www.westrowops.co.uk

  5. #5
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default Re: How do I create a table with totals from another

    I shouldn't think so. You didn't specify a path outside the database folder for the table to be created did you?

Similar Threads

  1. Totals from one table to another
    By Rich Hartnett in forum Web Application Server v7
    Replies: 1
    Last Post: 07-09-2008, 11:05 PM
  2. how to create new table
    By valieand in forum Alpha Five Version 7
    Replies: 5
    Last Post: 11-02-2005, 11:27 AM
  3. Create New Table ?
    By Keith Hubert in forum Alpha Five Version 5
    Replies: 1
    Last Post: 01-25-2004, 04:22 AM
  4. Running totals in indeded browes table
    By Gerald Osborne in forum Code Archive
    Replies: 2
    Last Post: 03-11-2002, 10:19 PM
  5. Browse table totals
    By Sam Wagoner in forum Alpha Five Version 4
    Replies: 6
    Last Post: 07-04-2001, 11:37 AM

Bookmarks

Posting Permissions

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