Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: Query: counting dates

    Hello,
    My problem:
    I made a query which extracts from tb1 patients name, adress, city and from tbl2 the dates of consultation. Result looks like:

    PatId | Name | Cons1 | Cons2 | Cons 3 | Cons4 | etc.
    1 | Johnson | 2-2-2004 | 17-2-2004 | 15-3-2004 | 10-4-2004
    2 | Peterson | 7-2-2004 | 15-2-2004 | 1-4-2004 | 7-4-2004
    etc.

    Next I would like to count which patients came how many times in out practice in a given period (mmmm yyyy), so we can send them a bill per month.
    I cannot figure out how to do this, so please give me some help.
    Thanks!
    Paul

  2. #2
    Join Date
    Jun 2002
    Posts
    59
    Paul,

    I think (if I am thinking along the same lines as you) that you have a few options here. Do you want to e-mail me a small sample and I will try and post the result her.

    Happy Easter

    Frank

Posting Permissions

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