I have no code at the moment, but I have been looking around.
I have an access database which I am using SQL to query/update
I can connect, I can pull info just fine, and I know how to update, but I have a specific request!
I was wondering if it is possible to do a sort of condition using unique
INSERT INTO part_info (DateValue, Part_Num) VALUES (value, value2) WHERE DateValue=Unique Or Part_Num=Unique
I am sure this isn't correct syntax, but I just wanted to give an idea of what I am looking for. I want to insert a new part if it is a different date OR a different part number. (both make the parts unique). Otherwise I want to UPDATE the existing part if the date and the part Number are the same. (this one is not as hard).
BUT could I use them within the same SQL call so that I don't have to query the database and make my own conditional?