Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Cross Tab Query Total Formula

Discussion in 'Information Technology' started by sborgemenke@cincinnatichamber.com, Jul 28, 2006.

  1. sborgemenke@cincinnatichamber.com

    Guest

    I have created a cross tab query in Access where I am taking the minium
    number of individuals registered for a specific event (column 1) and
    then I would like to have the total field add all of the columns with
    the minium number together for the total. Currently, it is taking ALL
    of the people registered for the event and adding them together.

    Does anyone know how to do this?

    Example of CT Query Columns

    Field: # Registered | Total of
    Quantity_Ordered: # Registered
    Table: 01 Safety Council | 01 Safety Council
    Total: Min | Sum
    Crosstab: Value | Row Heading


    Thanks in advance.

    Suzanne
     
  2. Loading...

    Similar Threads Forum Date
    Dialogue Across the Dinner Table Fosters Understanding of the Sikh Faith Interfaith Dialogues Feb 8, 2013
    Sikh News How A Sikh Engineer From Gujarat Developed A Ramadan App That Crossed Half-a-million Breaking News Jul 6, 2016
    Controversial No Gay Marriages, Gurdwaras across World Told Hard Talk Dec 17, 2013
    Controversial Namdhari Nitnem : Crossing The Line? Hard Talk Oct 3, 2013
    Canada Freeman movement grows across Canada Breaking News Sep 3, 2013

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    A crosstab requires 3 fields. I only see one field --- # Registered
    What is the other fields and their datatype?

    "sborgemenke@cincinnatichamber.com" wrote:

    > I have created a cross tab query in Access where I am taking the minium
    > number of individuals registered for a specific event (column 1) and
    > then I would like to have the total field add all of the columns with
    > the minium number together for the total. Currently, it is taking ALL
    > of the people registered for the event and adding them together.
    >
    > Does anyone know how to do this?
    >
    > Example of CT Query Columns
    >
    > Field: # Registered | Total of
    > Quantity_Ordered: # Registered
    > Table: 01 Safety Council | 01 Safety Council
    > Total: Min | Sum
    > Crosstab: Value | Row Heading
    >
    >
    > Thanks in advance.
    >
    > Suzanne
    >
    >
     

Share This Page