Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    70

    Unanswered: Selecting records

    Hey,

    I have a Schedule table where contacts have appointments.
    Sometimes a contact can have more than 1 appointment in 1 day. I want to be able to select all appointments for 1 day but only show the earliest one if a contact has more than 1.

    Thanks,

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Re: Selecting records

    Originally posted by vbgladiator
    Hey,

    I have a Schedule table where contacts have appointments.
    Sometimes a contact can have more than 1 appointment in 1 day. I want to be able to select all appointments for 1 day but only show the earliest one if a contact has more than 1.

    Thanks,
    Post your query for see the problem
    Saludos
    Norberto

  3. #3
    Join Date
    Jan 2004
    Location
    Saint Louis /USA
    Posts
    8

    Re: Selecting records

    Originally posted by vbgladiator
    Hey,

    I have a Schedule table where contacts have appointments.
    Sometimes a contact can have more than 1 appointment in 1 day. I want to be able to select all appointments for 1 day but only show the earliest one if a contact has more than 1.

    Thanks,
    The easiest solution is to use a SQL statement and order the records by date/time of the appointment. The first record would be the one you want.

    select * from table_name
    where contact_name='John'
    order by date_time _field

    Hope this will help
    Regards

Posting Permissions

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