• do you mean like this (based on my set up code)

    SELECT shost_name, COUNT(DISTINCT time_stamp) AS visits

    FROM MSA

    GROUP BY shost_name

    ORDER BY shost_name

    if not correct...please alter my insert script to represent what you want...and post back.

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day