Append data queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have current linked table that needs to be appended at the end of each month
to a running year to date table. Have a Date field in the YTD table and want
to make sure that current data is not appended more than once. For example,
if January 06 has already been appended and labeled as such in the YTD table;
then if another user tries to append the same data, an error message should
pop-up.

Help?
 
if each specific date (Jan 6, 2006; Jan 7, 2006; Jan 8, 2006, etc) will be
used in *only one record* in the table, then you can open the "year to date"
table in design view and set the Indexed property of the date field to

Yes (No Duplicates)

when you run the append query, dates that violate the unique index will not
be appended, period.

btw, if the date field in your table is named "Date", suggest you change it.
Date is an Access reserved word and, as such, it should not be used for
anything that *you* name in a database. see
http://home.att.net/~california.db/tips.html#aTip5 for more information.

hth
 
Back
Top