Welcome to SPN

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

Sign Up Now!

How to Group Records in a form by category

Discussion in 'Information Technology' started by Marixxe, Jul 28, 2006.

  1. Marixxe

    Marixxe
    Expand Collapse
    Guest

    Hello there!

    I just want to ask if its possible to group records in a form, example,
    getting the sum of records in Category A and then getting the sum of records
    in Category B, just like in reports? If its possible, could someone tell me
    how? Thanks!
     
  2. Loading...


  3. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    A calculated textbox using the DSum() function may be the easiest. It would
    depend on your form layout and how you wanted it displayed.

    --
    Wayne Morgan
    MS Access MVP


    "Marixxe" <Marixxe@discussions.microsoft.com> wrote in message
    news:A7EF999C-B97A-471D-AEF6-A2C4C370D572@microsoft.com...
    > Hello there!
    >
    > I just want to ask if its possible to group records in a form, example,
    > getting the sum of records in Category A and then getting the sum of
    > records
    > in Category B, just like in reports? If its possible, could someone tell
    > me
    > how? Thanks!
     

Share This Page