changing a field's caption based on data in another field

T

Thrava

Hi everyone,
Anyone knows how to do this?

In a query, I like the caption name (field name) to become
that of the content of the previous field.

In the query pane, every record in Field1 is the same, for
example 1/25/05. I want the name of the next field in the
query to change to the content of the first field (which
is in this case 1/25/05).
I need this to be dynamic because every week, the content
of the field1 changes.
I hope I made sense.
any help appreciated
Thanks
 
V

Van T. Dinh

If you keep having to change the Field name in the Query from week to week,
my guess is that the Table structure of the database has been incorrectly
designed/implemented.

The fact that a date value is used as a Field name is a major indication.
You should never store data (and a particular date is an item of data) in
Field names.

Suggest you find out a bit more about Relational Database Design Theory and
Database Normalization and check whether your database follows these
requirements. Access (and other database engines) are designed to work with
correctly structured Tables and tend to create difficulties with
incorrectly-structured databases since database engines are not designed to
work with these incorrectly-strucutred databases.
 
R

rKp

I agree with Van.

But if you know what you are doing, and really have this requirement, then
you can try adding the same field (that needs to repeat as header) to the
form again, and make it look like a header would, and remove the actual
header for the second field.

This is a work around, and it should work.

Rajesh
 
Top