Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2007
    Posts
    3

    Unanswered: help with database needed

    i am workin on queries, and i have forgotten how to do something with totals is there anyone who can help me?

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    There are many people here that can help. You probably need to be more specific in your question, though.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Apr 2007
    Posts
    3
    ok i have a query that i need to have the total field and name it totalinvestment with a caption, and the other fields in query are first name last name and investment amount. now on the total field i cannot figure how to do this because it would be a calculated field, but cant figure how to build it.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Make a new query based on your first, then try:
    Code:
    [Total Investment]: <calculation>
    George
    Home | Blog

  5. #5
    Join Date
    Apr 2007
    Posts
    3
    thank you for the information, now that ,that is done on to doing some calculated controls, man i hate those cause i always get it right in the footer but i always mess up in the main form.

    thank you for helping and responding

    jwb

Posting Permissions

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