Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kpsony
  • Content: Threads
  • Order by date
  1. kpsony

    Top 500 Donors

    I need to run a query on our top 500 donors. We have 2 DB's that are connected. One called "Main DB", the 2nd called "Gifts DB" They are connected through the DonorID. I need to do a query to find out our top 500 donors... ANy help?
  2. kpsony

    Query for top 500 donors

    I need to run a query on our top 500 donors. We have 2 DB's that are connected. One called "Main DB", the 2nd called "Gifts DB" They are connected through the DonorID. I need to do a query to find out our top 500 donors... ANy help?
  3. kpsony

    Query for Name/Address/And a single donation of $250 or more

    I work for a non profit and I need to run query to find out who in our DB has given a donation of $250 or more. We have 2 Tables on named "The TTP DB" and "tblegifts" They are connected through a column named "donor ID" These are the fields I need to have FIRST NAME/LAST NAME/ADDRESS...
  4. kpsony

    A List of Donors

    I work for a non profit and we need to do a query for a committee report. I have a table of Donors and a table of the Gifts the donors have given. They all have a unique donor ID, which is how their gifts are distinguished. I need to do a query on people who have ever given over $250.00. Any...
  5. kpsony

    Duplicate deletion

    I need to know how to delete any of the cells that have duplicates. Suppose I have a list of names, and I want to delete all the names that have duplicates in the list, so their compeltely out of this list... any help? Thanks
  6. kpsony

    Looking for non-donors

    Ok, I have to search through our DB to find our non-donors, we have a table that records who has donated (donorid), and number & Amount of gifts. I need to find out how to deduct all the people in the gift table, out of the main table. Any suggestions?
  7. kpsony

    Using 2 Queries...

    Ok, I made one query from our Main Table that has the last name, first name, donor ID, etc... I made another query from another table, but it has the Donor ID field as well, and im trying to match the names with the donor IDs. I create a new query, and use both queries and connect the donor...
  8. kpsony

    Connecting Main Table with Form

    In our DB, we have our main table, and our main entry form. Our main table is supposed to be recording all of the gifts that people have given, but its not. I go into our main form, and go under the peoples records, and all of their gifts are showing, then I go under the main table to look at...
  9. kpsony

    Searching for last gift...

    I work for a non-profit, and I'm trying to do a query on what everyones last gift amount given was... I cant seem to figure out a code. Is this even possible? I am fairly new to access, but do know the basics. Any help would be incredible. Thanks, Brian

Part and Inventory Search

Back
Top