Search results for query: *

I have it. I will experiment with the variations of Concat. Thanks for the lesson. I realize that Subqueries are very powerful in the hands of experts.

Duane, I confirm that the first of the last 2 queries works perfectly. I have not tested the second yet. I don't want to impose upon your kindness, but if you have a minute left, I have a very last question : in some families, the members have different names. Is it easy to have another column...

It looks like it is OK now. Let me investigate a little more and I'll come back. Bravo !

No joy. Both abort with « Syntax error (missing operator in expression... » "mm\/dd\/yyyy" is highlighted.

Duane, after receiving the post about subquery, I visited Allen's site and downloaded « Subquery basics ». I also searched other sites for problem similar to mine. Nothing found. Just a confirmation : As your tables were close to mine : a family table and a person table, I added 2 fields to...

After 4 days (and nights) trying all combinations, in spite of your kind help, I must admit, to my great shame, that I cannot do it. I am completely at large. I surrender. Many thanks for your patience.

Hi Duane, I executed your Query as is, but did not get exactly what I expected, close tough. All families are listed even there is no member born before the given date. I confim that, for preventing problems with date format, when asking for the date, I entered 01/01/1945 for my limit (I live...

Sorry Duane Before creating my own database, I wanted to experiment with what is in Concat2k just by adding 2 fields for limiting the number of guests. Only persons who are marked as Active and are born before a date entered on a form will be invited. I will use the query for a MailMerge...

Many thanks for your prompt reply. This is exactly what you sensed. I use your 2 tables : tblFamily and tblFamMem. tblFamily has 2 more fields : DateofBirth (Date) and isActive (Yes/No). I want to invite people to a meeting if : 1 - isActive is true 2 - their DateOfBirth is before a date...

Dear Friends I downloaded Concat2k from Mr Hookom. The example works perfectly. Now I am stick with a difficulty and need help for going one step further. If I have a date of birth and an IsActive field in tblFamMem, how do I write the select clause for limiting the output to people born before...