I
isliprlw
Hi,
I have a 'standard' range of queries that create the outputs from an
analysis database in Access 2003 (running in 2000 mode), and would like to
'tailor' the output from these queries so that the displayed field names can
be determined from a simple table.
E.g. the 'standard' output field is 'Directive', and I would like to set up
a simple lookup table with two columns. In the first colum will be the
'standard' field names and in the second column the specified alternatives.
For example in the second column the alternative of 'Client Category', so
that when I use the database with this lookup table the field will be
displayed as 'Client Category'. Then by simply populating alternate lookup
tables I can tailor the output as much as I need to.
Can someone tell me how to do this please?
Richard
I have a 'standard' range of queries that create the outputs from an
analysis database in Access 2003 (running in 2000 mode), and would like to
'tailor' the output from these queries so that the displayed field names can
be determined from a simple table.
E.g. the 'standard' output field is 'Directive', and I would like to set up
a simple lookup table with two columns. In the first colum will be the
'standard' field names and in the second column the specified alternatives.
For example in the second column the alternative of 'Client Category', so
that when I use the database with this lookup table the field will be
displayed as 'Client Category'. Then by simply populating alternate lookup
tables I can tailor the output as much as I need to.
Can someone tell me how to do this please?
Richard