Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Posts
    403

    Unhappy Unanswered: What approach to take

    I have set up a table which contains text of simple follow up letters to send to clients. These are sent on different days after their intial visit depending on the days gap selected.

    I then use a timer to print the letters at a certain time of day.

    I thought it would be better to have one report and then send the records to the report (this I have figured out) if they are required.

    It is deciding how to match the clients due the letter with the appropriate letter that is giving me a headache. I can see it can be done, but right now it is escaping me.

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    We are going to need more specifics here.

    What is the criteria you are using for matching customers to a letter?

  3. #3
    Join Date
    Feb 2002
    Posts
    403
    The criteria is last visit date.

    For example if today was the 30th of May

    All customers who came in on the 25th would be receiving a 5 day letter, the 21st a 9 day and so on.

  4. #4
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    So, your letter file may be keyed by a number representing the number of days since their last visit.

    And, when scanning the client file, with the last visit day, you can convert that last visit day to the number of days since the last visit, using:

    DateDiff("d",[LastVisitDay],Date())

    The query for your report could link this DateDateDiff with the letter file's key . . .

    . . . and there you have it.

    Ken

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •