Combining Data

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

Guest

I don't know if what I am going to ask is possible, but I though I'd ask the
experts.

I have a table listing items in a charity auction. If I wanted to combine 2
items into 1 new item, such as theater tickets and a restaurant certificate
into a new item called "Theater and Dinner", is it possible to get data from
the 2 individual items to combine into the data fields of the new item.

For instance, if the theater tickets has a Donor field of "X" and the
dinner has a Donor field of "Y", can I get the new "Theater and Dinner" Item
to show the Donor field as" X and Y".

What I'm trying to do is combine the data in the fields of the individual
items into the like fields of the new item.

Thanks

Kevin
 
Hi Kevin,
try a query string like:

UPDATE myTable
Set [Theater and Dinner] = [Theater Ticket] & " and " & [Restaurant
Certificate]
WHERE ((Not [Theater Ticket]) Is Null) Or (Not (([Restaurant Certificate])
Is Null));

I hope that it is obvious what is going on.
It will give you the result you want as long as both [Theater Ticket] and
[Restaurant Certificate] hold a value. Substitute myTable for the name of
your table.

HTH, ;-)

Ed.
 
Back
Top