Results 1 to 4 of 4
  1. #1
    sabrish72 is offline Novice
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    12

    Need Advise and Help

    Hi All...
    I need some help here and hope someone can help me ...

    I've created a table (with some data), one of the data is number
    Example
    Name, Category, Buy
    Alisson A 100
    Barn B 100
    Darren A 150
    Elise C 100
    Fuller B 100
    Gill B 150

    Then I create a query
    Query 1 is total of [buy] that is 700
    Query 2 is total of [buy] by [category]=A that is 250
    Query 3 is total of [buy] by [category]=B that is 350



    Then I create a report based on query 1 since its the biggest amount
    When I group by category Access can give me answer by category.
    My question is :
    If i need the data from query 2 to be in my report, how can i do it?
    Or maybe I just need 1 query rather than 3?

    Hope the info is enough ...

    Trillion Thanks ...

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Base the report on the table directly (no need for a query here). In the report, set up a group level on the category. Add a footer for the group and put in a control for the category total. Also, put in a report footer with a control to handle the grand total. I've attached an example database.

    BTW, the word "name" is a reserved word in Access so it should not be used as a field or table name.

  3. #3
    sabrish72 is offline Novice
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    12
    Thanks,
    I really appreciate this ..
    I will remember the "name" word use from now on...

  4. #4
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You're welcome, good luck with your database.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Newbie Need Guide and advise on Query
    By sabrish72 in forum Access
    Replies: 3
    Last Post: 05-24-2011, 08:44 PM
  2. Can anyone advise?
    By doceo in forum Access
    Replies: 0
    Last Post: 10-18-2009, 02:44 PM
  3. Some advise for a complete novice...!
    By 450nick in forum Access
    Replies: 1
    Last Post: 09-11-2009, 02:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums