Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding a column (off 97)

    hello all,

    I have developed a DB that imports and excel file of financial data, which will occur daily. i then have a query that finds the unique entries in the DB. the user is able to go to a form and select the account # the wish to view. all unique transactions then appear based on the acount # selected from a list box. this is all working properly.

    what i need to insert is another column that will display the sum of all the credits/debits FOR EACH INDIVDUAL number. i've tried the wizard but the sum that is returned is not for the selected account number. when a user uses the form to find all transactions for account #123, all the info should be displayed with a column at the end that displays a total for the currently viewed data. how is this done? step by step details would be great;y appreciated as my access skills are not great. thank you veyr much.

    Ed

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Adding a column (off 97)

    I'm not sure I understand what you mean by "Adding a column". Adding it to what? A table? A query? A report?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Adding a column (off 97)

    I'm guessing that you want a control (not a column) that would be a sum for the Account you have selected. Use a dsum to do this. A DSum as the recordsource of the control would be as follows:
    =DSum("Amount","Tablename","Account=" & textAccount)
    The assumptions I have made is that textAccount is a control on the form, and you must change the names of Account, Tablename and Amount to your own names.

    HTH
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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