Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Totals query (Access 2000)

    I need an advice how to build a totals query combining both the margins and the expenses for each month.I am applying the attachement with the problem.The expenses for each month are written in the table MonthlyOutlays and the margins are expressed with the query QryMargins.This wonderful query was built with the help of this Forum.But how can i relate this query with the outlays ?
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Totals query (Access 2000)

    The contents of the table are an autonumber field and a monthly outay, you will need a onth in this table?

    That monh field will be used to join the table with the query you have.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Totals query (Access 2000)

    As patt noted, you will have to include a date field for the month in the MonthlyOutlays table. An AutoNumber field is not suitable for that because it is assigned by Access automatically, and you'd be able to use it fo one year only.

  4. #4
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals query (Access 2000)

    Thank you both of you. I have done what you have recommended and made the table MonthlyOutlays.On my report the data are arranged by monhs. is it possible to call the outlays for the corresponding month using some kind of DLookup ?
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Totals query (Access 2000)

    You need to create a query based on the Outlays table that computes the month in the same format as used in the other queries. You can then add this query to qryMargins and join it to the other queries on the month field.
    See the attached version.
    Attached Files Attached Files

  6. #6
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals query (Access 2000)

    That was exactly what i aimed at. Thank you so much indeed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •