Search results

I haven't used Access in years and my logic abilities aren't what they used to be. I've volunteered to take over a scheduling job at my church, thinking I could easily make a db to handle it. But there are so many elements and exceptions, I'm not sure that it's within my abilities to create a...

Donor/donations database: for the most part donations come from individuals, so somewhere in my db I've got "donor" equaling the Title, First Name, and Last Name. BUT now I've got some institutions donating and since the person writing the check might change but institution won't, I think in...

Things have been working well with my charitable donations database--until I discovered a problem with a calculated field "Greeting" [Title] & (" "+[Last Name]). The "Title" field has Mr., Mrs, Mr & Mrs, Ms., Miss, Rev., Rev. Mr., etc. to choose from. There's also a field "Address as" (don't...

Thought I was finally ready to make a mailing to our donors but noticed that some were coming out 2 to a page. For instance, Mr. and Mrs. Smith's donation appeared on the same page as Mr. and Mrs. Jones'. So I put in a page break after the total of their donation--and now I"m getting blank...

This ought to be very simple, but I've been searching online for quite some time and can't find how to add today's date to a report formatted as "August 30, 2014." I can't understand why that's not one of the options when inserting a date. Sorry if this is something that has been asked...

Need to track donations in two areas. Have one query that tracks them in location A and one that tracks them in location B. Same query, no other difference. Report made on location A is fine. Made a copy of it and based it on the 2nd query--and I get a pop-up "Enter Parameter Value" for Last...

The goal is to send each donor a list of their year-to-date donations. I actually thought I had what I wanted till I realized that two sisters with the same last name and the same address were not getting their own statements. I had grouped on last names so any duplicates were lumped together...

Not sure if I should have posted this under tables or forms. But if different people will be entering data into a "new donor" form, how do I keep them from adding the same person a second time? It's possible people could have the same name, and it's possible that two people at the same address...

I'm using an Access template called "Charitable Contributions web database" (converted to desktop) that has a calculated field that takes a donor's first name and last name and creates a new field using first name and last name. So First Name: John Last Name: Doe Results in Donor: John Doe...

What I'm trying to figure out (as a novice) is whether Access has the capability of generating letters to thank donors for their donations. Want to create a db of donors and their donations and then be able to produce letters to thank them--whether as a one-time donation or as a quarterly/yearly...

There's a post on the same subject from 2011; hope no one will mind my reintroducing this topic. The particular web db I'm looking at is the "Charitable Contributions Web Database." I did try the instructions in that original thread but got confused immediately, not understanding how to...

I'm from Chicago but now living in the southern U.S. Used to use Access 10-15 years ago, designing simple databases on a temp/contract basis. Not advanced by any means. Been using Access for personal use mostly to keep my knowledge up. I now have an opportunity to do some Access db design for a...