I have a form with an unbound text box which the user enters a date into. Then a button is used to run an append query which
adds transactions for that date to a table. I want add a criteria to the append query which will stop it from adding
transactions to the table if the date entered on the form is already listed in the table (I am trying to keep them from
adding duplicate records to the table).
My SQL is below. Without the criteria the appendquery works. However, when I added in the criteria to check for the date from
the form for the same date in the table I get the message that 0 records will be appended to the table even when the date
from the form is not listed in the table.
Do I have the criteria wrong? Do you need more information?
WHERE ([Asset Depreciation Table].ME_DATE)([Forms]![Calculate]![MEDATE]);
I will appreciate all assistance!!