Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page