Recent content by Howie2018

I created a database based on data exported from excel. I followed through with the wizard which automatically created the relationship and look up tables for me. There is now a problem I am facing on two of the generated tables. I am having 2 identical departments with two different ID. The...

Hi All I am creating a database and I want to prevent duplicate records on data entry. I want it based on Firstname, Surname, E-mail address and Department. I have put the following code in the calculated field in an expression but it doesn't like it. =IIf(DCount("*","[ALL...