Search results

I'm trying to figure out how to query to get the max donation date of a customer. I want to say: max(Donations.DonationDate) < 04/01/2007 When I try to perform the above in the criteria field it says "Aggregate Functions Cannot be used in a WHERE clause". I need to find people who have not...

I have several tables containing information about donors to our charity. We need to send a letter to donors that have not given in the past year, who have also given an amount equal to or larger than $100 in the past. My main concern is the first part. We have a "contributor data" table that...

Hi, I have an access database that contains information on donations made to our non profit organization. I'm wondering how I query for people who have donated in categories (a,b,c) between 01/01/05 - 01/01/07, but have NOT donated in categories (a,b,c) in >01/02/07. In other words I'm...

I have a report that I'm looking to email as opposed to fax. What's the easiest way to achieve this? Any and all advice appreciated. Thanks! d

I'm having a formatting issue in my report. I have a combo box containing several donation types. When I look in the combo box properties it is missing the usual can grow/can shrink options and is truncating the values in the report rather than wrapping them. Anybody know whats going on here...

I'm fairly new to access but am generally computer savvy. I have an access table of donations that is related by customer id to a table of donator information (company, address, etc). I have created a query based on the donations table that singles out donators of a specific type, using...