You might still have to provide some context for us to fully understand your question. If you go to the table's design view, you can manually name the field to whatever you want.
The data in the column is an equation based on the number of vehicles in another table. The users would like to have the number of vehicles used in the equation shown in the header.
This still does not really make any sense. Can you provide a sample db or some table data? It almost sounds like something you would do in a cross tab query, but not in a table.
Thanks you everyone's help. From my research and what everyone has said, naming a column in a header based on a value in another table is not possible.
Thanks you everyone's help. From my research and what everyone has said, naming a column in a header based on a value in another table is not possible.
You posted this question in the table forum and specifically used the term "table" in your question. Users should not interact directly with tables in a database. Instead they should access data via Forms and Reports. Putting data into headers of those is possible and trivial.