DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: access sql

  1. #1
    Tina Guest

    access sql


    Can someone please help me with formulas. I am trying to calculate sum of
    hours in column B for each datapoint (person) in column A. My problem is
    that I don't know how to have access calculate a query or report because
    I have several datas in column B for each person in column A.

    Thank you sooooo much for your help

    Tina

  2. #2
    Bitbucket Guest

    Re: access sql


    May I suggest a group by Column A (person) and then use the 'SUM' function
    for column B.


    "Tina" <titanila@hotmail.com> wrote:
    >
    >Can someone please help me with formulas. I am trying to calculate sum of
    >hours in column B for each datapoint (person) in column A. My problem is
    >that I don't know how to have access calculate a query or report because
    >I have several datas in column B for each person in column A.
    >
    >Thank you sooooo much for your help
    >
    >Tina



  3. #3
    vinay mishra Guest

    Re: access sql


    "Bitbucket" <nospam@hotmail.com> wrote:
    >
    >May I suggest a group by Column A (person) and then use the 'SUM' function
    >for column B.
    >
    >
    >"Tina" <titanila@hotmail.com> wrote:
    >>
    >>Can someone please help me with formulas. I am trying to calculate sum

    of
    >>hours in column B for each datapoint (person) in column A. My problem

    is
    >>that I don't know how to have access calculate a query or report because
    >>I have several datas in column B for each person in column A.
    >>
    >>Thank you sooooo much for your help
    >>
    >>Tina

    >



  4. #4
    cgill Guest

    Re: access sql


    "Tina" <titanila@hotmail.com> wrote:
    >
    >Can someone please help me with formulas. I am trying to calculate sum of
    >hours in column B for each datapoint (person) in column A. My problem is
    >that I don't know how to have access calculate a query or report because
    >I have several datas in column B for each person in column A.
    >
    >Thank you sooooo much for your help
    >
    >Tina



    All of this can be done on the report level. When creating the report, choose
    grouping options and group the report by person (column A). You can then
    total the hours (column) in the detail section which will give you a total
    for all in the group (column A). You can then total that in the report footer
    for a grand total. This can also be done with the report wizard when prompted
    for grouping and totaling.....

  5. #5
    asdfasd Guest

    Re: access sql


    "cgill" <cgill@cosc.maricopa.gov> wrote:
    >
    >"Tina" <titanila@hotmail.com> wrote:
    >>
    >>Can someone please help me with formulas. I am trying to calculate sum

    of
    >>hours in column B for each datapoint (person) in column A. My problem

    is
    >>that I don't know how to have access calculate a query or report because
    >>I have several datas in column B for each person in column A.
    >>
    >>Thank you sooooo much for your help
    >>
    >>Tina

    >
    >
    >All of this can be done on the report level. When creating the report,

    choose
    >grouping options and group the report by person (column A). You can then
    >total the hours (column) in the detail section which will give you a total
    >for all in the group (column A). You can then total that in the report

    footer
    >for a grand total. This can also be done with the report wizard when prompted
    >for grouping and totaling.....


    <i>sadfs</i>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center