U
unhinged
G'day,
I have been given an Excel file and asked to move some of its contents
to Access. The raw data is not a problem, but I also need to mimic the
display method that has been used on one of the worksheets.
One of the worksheets acts as a data table, with various calculations
used to implement the business logic. I have set up a query to
implement this in Access and it is working correctly.
The display worksheet, however, has been implemented such that the
user selects a primary key value and all of the rows in a column then
display the relevant information from the data sheet, eg:
Col A Col B
Address 1 Any Street
Phone 1234567890
email [email protected]
Each row of the display worksheet also has notes relating to the field
being displayed, so I have put the contents of a display worksheet
into another table and included the index value of each field name in
the query I created (qMapping). For example, in tDisplay the first row
would have "Address" and "15" as the index because the Address field
is the 16th field listed in qMapping.
Can anyone think of a (preferably simple) method which allows me to
present the information in a similar fashion to the Excel system?
Thanks in advance,
Daniel
I have been given an Excel file and asked to move some of its contents
to Access. The raw data is not a problem, but I also need to mimic the
display method that has been used on one of the worksheets.
One of the worksheets acts as a data table, with various calculations
used to implement the business logic. I have set up a query to
implement this in Access and it is working correctly.
The display worksheet, however, has been implemented such that the
user selects a primary key value and all of the rows in a column then
display the relevant information from the data sheet, eg:
Col A Col B
Address 1 Any Street
Phone 1234567890
email [email protected]
Each row of the display worksheet also has notes relating to the field
being displayed, so I have put the contents of a display worksheet
into another table and included the index value of each field name in
the query I created (qMapping). For example, in tDisplay the first row
would have "Address" and "15" as the index because the Address field
is the 16th field listed in qMapping.
Can anyone think of a (preferably simple) method which allows me to
present the information in a similar fashion to the Excel system?
Thanks in advance,
Daniel