depending on where you are showing this addition, you can
add the fields directly in a textbox control on either a
form or report if you have the datapresent on the form or
report.
You could also create a query that you create and
expression that is the addition of each of the columns
you wish to show. Then, on your report or form you can
place that expression as the controls source.
Relationship are helpful but necessary for things like
this. One of our current projects has over 200 tables
and we have nothing in the relationship area. Great for
wizard stuff because other wise the wizard will error out
on you telling you that there is no relation.
ds
-----Original Message-----
I need to add 2 or more columns from different tables,
how is this best done? I had problems creating
relationships between my tables also.
