Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding up a column (office 97)

    Hello everyone 2 things

    1st-
    I would like to make a query where the user could select an ID from a list as well as a begin and an end date to search within. the data from the table would then be extraced with all accounts under that ID for the time period selected. i know i have seen a greater than this date, less than this date feature but have no clue how to implement it. FYI - each row of data for all ID's have a transaction date that i would be referencing it to. Could someone please provide the details.

    2nd

    I would also like to make a similar query but instead of only showing all the individual transactions under an ID for the period i want my output to add up the' transaction cost' columns for all the data contained. i just need anm addition feature for a column and i can then use a report to display it. thanks a million.

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding up a column (office 97)

    1st-
    When creating your query using the design grid, specify something like "Between [Enter Start Date] And [Enter End Date]" for the transaction date criteria and [Enter ID] for the ID criteria (make sure they're in the same criteria row (causing the AND logic to be used between the two conditions).

    2nd-
    Similar to the above, but specify a "Totals" query. You then specify "Where" in the "Totals" row of the design grid for the ID and Transaction Date fields and use the same criteria as above. Add the Transaction Cost field to the grid and specify "Sum" in the Totals row.

    This is a little sketchy, but will hopefully get you going down the right path. If you need more help, holler!

Posting Permissions

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