Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Vaudousi

  1. Vaudousi

    Concatenate

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

    Concatenate

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

    Concatenate

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

    Concatenate

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

    Concatenate

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

    Concatenate

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

    Concatenate

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

    Concatenate

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

    Concatenate

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

    Concatenate

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

Part and Inventory Search

Back
Top