I need to pull information from two fields in a table into
one field in another. I am trying to condense it into one
step but didn't know if it was possible. Right now I have
to run a query for the one record and then go append the
results from the second query into the record.