Search results

Ah...so if I can design a header that looks like our letterhead, could you help me figure out how to add the personalization? ("Dear Mr. Schmoe") And how to place the address properly for a window envelope (although we don't have them right now, we could have some printed). I'm at the org...

Huh? :eek: Are you saying that in a REPORT you can say "Dear Joe Schmoe, Thanks for the following donations?" Then list the donation(s)? Plus have an address placed correctly for a window envelope??? I've never seen an example of this: reports have always looked like...reports. Not letters...

Is there a way to fake a letter format in a report? In the db I was creating on my own, I was able to produce a report that had one page per donor and their multiple donations. Personally, I thought it was pretty good and got the job done. I was able to show name and address in a...

Good point. I would probably create a query that specifies a certain period of time. However, I'm just now remembering that our parish sends a quarterly report that DOES include previous contributions, so that with each new one we can throw out the old report, ending with the 12/31/XX report...

Previously, the organization was simply saying, "Dear Joe, Thank you for your donation of $50.00..." I would like a letter that says "Dear Mr. and Mrs. Schmoe, Thank you for supporting our organization with your generous donation(s): Date of donation (tab) Amount (tab)...

Ah...there we go. I just entered a new fake donor with no title and the name is as it should be. Thanks! I just poured some fresh iced tea...cheers!

So where do we go now? Should I switch over to the other thread and continue with the mail merge attempt? Edit: posted this at the same time your post above appeared. So I'll make that adjustment and then switch to the other thread... 2ND EDIT: Wait a sec--should that "MiddleInitial" be...

I have to admit I've lost the train of thought...guess I should re-read this thread from the beginning. But I created the "AddressAs" field to add to the "Thank You Letter Query". I think that's where I decided I didn't like the field "Donor" which is first name first and would rather have...

Sorry--family issues interrupting. Now that I've got my head back on straight (hopefully), it's the Donations by Donor form that I most want to translate into a letter. Is that where we are? Or should this be discussed in the other thread I started "Generating thank you's"?

To your first question, yes, I added the "AddressAs" calculated field to the Donors table--only because I was trying to copy what the designer did with DonorName (and wondering if I could get rid of DonorName, using FileAs in most instances). "AddressAs" is only there because I didn't know where...

How funny: you're the first person who hasn't given me an argument over it--much less totally agreeing. Great minds... :D Talk to you tomorrow!

All but "AddressAs" were there in the original db. I have no idea either why TotalDonated is in the donor table--there are a bunch of things I come across and wonder why they're there but am afraid to delete them just yet. (I DID get rid of the User table, though.) FilesAs: LastName, FirstName...

Okay, let's see if I can upload it here. Here's what I'd like to be able to do right off: In the Donors table, I want to replace "DonorName" with "FileAs". That means, instead of the many instances throughout the entire db of "DonorName" being shown as "John Smith", I want to instead use the...

So that would be "cannot be blank" or whatever the phrase is? Thanks!

I could make a copy and put some fake info in it. How can I share it with you? Edit: Shoot! I did something bad and messed up that Donor table. Will re-import the original but it looks like I have to re-do a bunch of stuff I did last night...oy. :banghead:

Okay, help me with another problem--please. The Donations table in the template has a field called DonorID with these particulars: Type = Number (That's my first question: why "number" when the result is text?) Field Size: Long Integer Lookup: Display Control: Combo Box Row Source Type...

Didn't want to bother you if you were still sleeping... ;-) I was just now trying to figure out how to simply combine Title, FirstName, and LastName in one field. Seems that it ought to be easier than the above expression. Is there a way? Haha! Just got it: [Title] & " " & [FirstName] & " " &...

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

Okay, I'm tired too. I'll use the form with subform tomorrow since it's got all the data I want. Haven't created a command button in years, but I'll await your instructions on what it should do/say. Pleasant dreams...

I'm just not exactly sure how this will work since everything I've read says that mail merge only works from queries, not forms. I don't really care which one we use--it's just that the form with subform gives me what I"m looking for. The simple one simply gives me every single donation --...