Recent content by kpsony

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