update fields

  • Thread starter Thread starter Kelly Z.
  • Start date Start date
K

Kelly Z.

I am creating a database that will track contacts,
donations they give and the letters I send to them as
appeals.

The donations and donation requests are set up as
separate tables and subforms--so I can have a one-to-many
relationship with each.

Sometimes, one letter will go out to EVERY contact in the
database. Is there any way I can perform a "global
entry"?
 
Hi Kelly,

Assuming you have a table that stores ContactID and
DonationRequestDate, you could create an append query
that would append all ContactID's from the Contacts table
to the ContactID field and the current date using Date()
to the DonationRequestDate field.

To do this using the query builder, you would add the
contacts table to the query, change it to an append query
that will append to the donation requests table, add the
contact ID field from the contacts table to the query
grid, on the append to line select the ContactID field in
the destination table, then create a calculated field in
the query grid by typing "Date()" without the quotes and
choose the donation request date field as the destination
field.

This would append a record to your donation requests
table for each contact in your contacts table, with the
current date as the date entry.

If you were doing this on a different date than the
actual request, you could enter a specific date to be
used by typing #mm/dd/yy# with the appropriate month, day
and year values included. Don't forget the # signs
though or it will interpret the expression as division
rather than a date.

HTH

-Ted Allen
 
Back
Top