Re: Access DB: Preventing duplicates! arrrh
SELECT tbl.ID, tbl.TeamPeople, tbl.DateRecieved, tbl.ProspectName, tbl.[Type Of Business], tbl.AmountofCredit
FROM tbl
WHERE (((tbl.ID) In (SELECT [ID] FROM [tbl] As Tmp GROUP BY [ID],[TeamPeople],[DateRecieved] HAVING Count(*)>1 And [TeamPeople] = [tbl].[TeamPeople] And [DateRecieved] = [tbl].[DateRecieved])))
ORDER BY tbl.ID, tbl.TeamPeople, tbl.DateRecieved;
query would be something like this, I am using my own table fields. Since, ID can not be duplicate its an autonumber, leave out that field. I just used it for an example. Hopefully, it will make sense to you. Now, what else can you do, beside only creating query and putting it in load events. You can also generate a search engine, where you would be needing a query and as well as vb script. This would be another form and she would be able to search her way through and locate the availability of the room depending on different fields. I have one hellova search engine, that I have used several times, but in diff design. If you want that, I can you pass u that file.