Recent content by vicdsfbayarea

Alan, Thanks. Then I would join the donations query (with those who have null amounts) to the attendance query, and that would give me all who attended but didn't contribute. Right?

I have two queries resulting from two different tables. One query gives me all attendees (to a charitable event) and the other query gives me all donors (may have attended the charitable event or not). What I would like to do is create a query to identify all the attendees that did not make a...

Paul, Thank you for such a quick reply. However, I am probably too much of a newby to make this work. Could you put some detail around how you would make a form selectively control what is probably an underlying parameter in a query controlling the generation of a report? You could also point...

The objective is to produce a report for non-profit telephone callers so that they can call potential donors. I have a query for which I can set a criteria (e.g. caller 1) but the output is ugly. d I also have a report that shows all of the potential donors (plus details) and all of the...

Thank you, Bob. You have given me enough clues to give it a try. This is new information that was not in the manual I have been using (Missing Manual). I appreciate it very much. Will re-post will success. Best regards, Vic

Bob, Thank you very much, especially about subreports. First of all, the commercial front-end process that keeps track of all of the family data spits out a single file with everything. As a separate process I've queried out the family and individuals into a total of five separate tables linked...

Bob, Thank you for your words of wisdom. Question: Is there a rational way to display the results of multiple queries on one report? I need a 1-page report for each family. The format is (1) some words and a logo, (2) family info, (3) more words, (4) member's name and 3 -4 data fields, (5)...

Thank you dairy farmer. Indeed, there is already the presence of a numerical "family id" in each of the five tables. There is also an ordered sixth table with everything in it, and it is coded with the relationship of each individual as well as the family ID. (This was the "mother" table which...

I'm a relative newby and need a report strategy to assist a non-profit create a report - "annual update" pages that are mailed to their membership once per year. The information for the report (one page per family) is in five tables. The first table is the "household table" and contains address...