Combining Data

[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

 

[Ed Adamthwaite]

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.