Altering table headings ?? (1 Viewer)

[LNewton]

Is it possible to add information from a field in one table to the heading in another table? There is a variable that is required in the column heading.

 

[WayneRyan]

LNewton,

I don't understand your question. Tables don't have headings.
If you mean joining two tables in a query for a form or report
than it is quite easy.

Please be more specific and you'll get help.

Wayne

 

[Autoeng]

I'll bet that LNewton means from one form field to another form header. In that case it would be:

Place a text box on the form with control source

=[Forms]![yourformthatcontainsthefieldtocopyfrom]![thefieldonthatform]

Autoeng

 

[LNewton]

Column Headings in a table

I have two column's within a table. I need to add information to the column name's, such as a date range that will change. I then export that table into excel.

 

[Autoeng]

No way that I know of to do it programmatically but if you right click on the column you can rename it.

Autoeng

 

[LNewton]

Renaming Columns

I'm not having much luck either. Thanks for the help. If I come up with anything I will post the answer.

 

[LNewton]

I finally created a Create Table function. When I defined the fields I inserted a variable within the field name to update the information I needed. Might help someone else. Thanks for the input.