can i just make parse out the date, and not worry about the time? that makes sense i think.

yes! that's it. thank you

okay, i figured out another way to do it. apparently you can't use an OR in a WHEN clause, or if you can, the syntax is different

Here is a much-abridged version of the code:

update TEMPTESTDATA

set Accession# =

Case Accession#

when Substring([TEMPTESTDATA].[LAB_Accession_Num],2,2) = '02'

or Substring([TEMPTESTDATA].[LAB_Accession_Num],2,2)...

SQL keeps rejecting the expressions in the WHEN clause. If I put a value in WHEN, it works; but I need it to be a logical expression.

Any...

the unique constraint did the trick. thanks

The field "A_Number" in the table "C_Cases" should not allow a value unless the same value appears anywhere in the field "A#" in the table "T_Data"; but "T_Data" is not...

how?

no. how can i do implement explicit transactions?

Can you tell me how to figure out which MDAC package I have? It's whatever came with the OS.

Anyway, the tables are all fully indexed, and I do have...

The tables are linked. Eventually, when some other projects wrap up, I will replace most of the Access stuff with more functional SQL Procedures, but I don't have time...

That makes sense. For data warehousing.

I do have a lot of joins thta I have to do, because of how well normalized my databases are. I am...

perfect. thanks

Thanks. That works.

Thanks alot. That was easy!