Search results for query: *

I need assistance to create a comparison variable for an MSWord letter merge that will place the correct value in a field after it has evaluated two fields. It is for a tax receipt & the letter details both their gift amount & tax deductible amount if the donor received a premium...

Just letting you know that we discovered how to capture the records in an easy query: 1) pulled in both queries; 2) linked them via the constituent id; 3) double-clicked the '*' in the primary query (FP06 Athletics Phonathon); 3) selected the unique id of query FP06 Exclusions checking the box...

To answer both of you: yes, I would like to capture the records that dropped from FP06 Athletics query#1. Since the conditions do not meet a theta join, what is a sub query? I thought that my left join was subbing the exclusions from FP06 Ath query#1. Might it be possible for you to give me...

I need to capture records that have dropped from joining two queries. When right-joined these records dropped and this was fine until it was decided we would like to capture the dropped records, research them, and clean them up. I found a book that refers to theta joins --- however I'm a...

I do not have VBA knowledge or programs/software. Can this still be done (via Access)?

I'm trying to save the actual query so that they can see my linkages.

Is there any way that I can save a query onto a public drive so that my boss can review it? I've just tried creating a new db, then importing the queries as tables, and finally importing the queries themselves only to find: 1) my links are not there; 2) some of the queries do not seem to...

How do I show all of the criteria used in my query in a report? I would like to place this information at the top or end of the report so that once it is distributed to my development officers they can see the criteria & query name and request a refresh of same. I'd like to see: 1. Query Name...

How do I show all of the criteria used in my query in a report? I would like to place this information at the top or end of the report so that once it is distributed to my development officers they can see the criteria & query name and request a refresh of same. I'd like to see: 1. Query Name...

THANKS TO BOTH OF YOU FOR YOUR PROMPT RESPONSES! Found out I should have corrected my thread to state that I needed to use both fields so that they would appear as standard phone listings in a document: (247) 545-3715. So I modified both of your suggestions: "("+{areacode}+")"...

Have used some general Crystal formulas, and now must learn advanced formulas & SQL---so I hope to use a lot of those great archived threads & tips within this forum! Crystal 8.5 user with 2 basic questions: 1) I have a text (String [7]) characters that contains a 'telephone' number. How do...