G
Guest
Sorry in advance for cross posting this question - this
belonged in the forms group rather than tables.
I use Access 2003 linked to SQL 2000 tables via ODBC.
I know how to make a column in SQL prevent duplicate
values with an index; however, I have a column where many
values are Null which is OK, but I can't use an index to
prevent duplicate Not Null entries because it will only
allow me one record with the null value.
Does anyone know of a work around where I can root those
out and at least pop up a warning to the person entering
the record that the value exists in another record?
I haven't had much luck using DCOUNT in the expression
builder.
Thanks in advance if anyone has any examples of
expressions that will do this,
Ben
belonged in the forms group rather than tables.
I use Access 2003 linked to SQL 2000 tables via ODBC.
I know how to make a column in SQL prevent duplicate
values with an index; however, I have a column where many
values are Null which is OK, but I can't use an index to
prevent duplicate Not Null entries because it will only
allow me one record with the null value.
Does anyone know of a work around where I can root those
out and at least pop up a warning to the person entering
the record that the value exists in another record?
I haven't had much luck using DCOUNT in the expression
builder.
Thanks in advance if anyone has any examples of
expressions that will do this,
Ben