This is a SQL Server. Here's the code in question (if that helps, with DISTINCT in it):
If DisplayPeriod then
If IsDate(request.form("BeginDate"

) and IsDate(request.form("EndDate"

) then
Before = request.form("BeginDate"

After = request.form("EndDate"

DisplayGood=true
sqlmeet= "SELECT DISTINCT Meetings.ID as MeetID, * FROM " &_
" ((XGrouptoUsers INNER JOIN Users ON XGrouptoUsers.UserID = Users.ID) " &_
"INNER JOIN Groups ON XGrouptoUsers.GroupID = Groups.ID) " &_
"INNER JOIN (Meetings INNER JOIN XMeetingsToGroups ON Meetings.ID = " &_
"XMeetingsToGroups.MeetingID) ON Groups.ID = XMeetingsToGroups.GroupID" &_
" WHERE MeetDate >=' " & Before &_
"' AND MeetDate <=' " & After & "' AND Users.ID = " & session ("USERID"

&_
" ORDER BY EndDate DESC "
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open sqlmeet, conn, 3, 3
if rs.recordcount > 0 then
WeHaveRecords = true
end if
Else
Response.Write "<p align=center><b> Please Enter Valid Dates!</b>"
end if
end if
[sig][/sig]