Replicate column info

[SS]

Hi- I had a question earlier about replicating columns for a project I'm
doing. There is one column that has the info being pulled from a form.
Another column in the same table needs to pull in the same information. In
excel you would use the equals sign to pull the same info. How would you do
that in access?

Thanks in advance

 

[Pat Hartman]

You would never do this in a relational database. If you want to see the
column twice on a form or report, just bind a second control to the same
field.

In the case of a query, you would never do this unless you were creating a
query that was to be used to export data to a spreadsheet. In the case of a
query, you can select the same column multiple times but each instance needs
to have a unique name so you will need to use an alias or the "duplicate"
field name will end up being Expr1.