Search results for query: *

I'm sorry, but I am very new access, what is the code that I need to put in the SQL part?

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?

The problem with that is the way our Database is set up. When someone donates more that once, it adds them into the DB as follows: First/Last/DONORID/AMOUNT/Date Jack/Wilson/1131/$20.00/01/03/04 Jack/Wilson/1131/$45.00/07/05/04 So, if we sort Ascending or Descending, it will bring up the...

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?

It automatically puts the quotes, and what is a Character string? :-D

I wish it were that easy, still the same error. <"250.00"

I got the query done and in the criteria part of the Gift AMOUNT field I put <$250.00 and its giving me an error of "Data type mismatch in the criteria"..

The DonorID/Gift Date/Gift Amount/ are in the 'tblegifts' FIRST/LAST/ADDRES/CITY/STATE/ZIP are in the 'TTP Database" Thanks

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...

I wanted to total by first & last name with their address. Thank you for all your patience

oh boy--now im getting 'Join expresson not supported' then it highlights [Donor ID] = [Gift ID]

Sorry, I am still having trouble... I've tried this SELECT [FIRST NAME], Sum(GIFT AMOUNT) As Total FROM [The Trevor Project Database] AS D INNER JOIN tblgifts AS G ON [Donor ID] = [Gift ID] GROUP BY [FIRST NAME] HAVING Sum(GIFT AMOUNT) > 250 It still is not working--saying missing operator...

LOL, I'm sorry--long day...

The Fields are as follows: FIRST NAME/LAST NAME/PRIMARY ADDRES 2/ -- in our Donor DB GIFT AMOUNT/Date of Event/Donor ID/ -- in our Gift DB

It says enter parameter value for d.name... ?

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...

That code doesnt seem to be working... I have a list of #'s (donor IDs) and I have them in column A, and in Column B I copied that code to B1 and Copied it down the entire column... It's putting 1's next to soem that are not doubled...

Suppose I have a list of Names of people who have donated to us. Then the MAIN list of EVERYONE in the DB (including the donors), I need to take the list of names of donors out of the MAIN list...

I want to find all the names that have duplicates and delete them all, even the originals, so there name is no longer in the list... any help?

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