Counting records

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sjoseph
    New Member
    • Oct 2006
    • 4
    #1

    Counting records

    Newbie here - I need help. I am trying to calculate the number of time a particular date was requested. On the 5th request the user should get a message that states that the date is not available.

    I have the following tables:

    ScheduleTable
    *Emp ID
    *RequesteedDate
    *Confirm
    etc..

    and

    DateTable
    *Date
    *Tally (number of times requested)

    Can anyone tell me how to do this?
    Tags: None
    • Killer42
      Recognized Expert Expert
      • Oct 2006
      • 8429
      #2
      Originally posted by sjoseph
      Newbie here - I need help. I am trying to calculate the number of time a particular date was requested. On the 5th request the user should get a message that states that the date is not available.
      I have the following tables:
      ScheduleTable
      *Emp ID
      *RequesteedDate
      *Confirm
      etc..
      and
      DateTable
      *Date
      *Tally (number of times requested)
      Can anyone tell me how to do this?
      At the simplest level, perhaps using a query with WHERE Tally < 5 would be enough?

        Comment

        Previous template Next
        Working...