I have a table of data that I have created using MS Query. This refreshes frequently when the source data is updated. I want to have two extra columns to contain data that is entered manually.
However when I have tried this I have noticed that when extra rows are added to the table the manually entered data does not stay on the same row as that data it was entered against.<o></o>
Is there a way to make the data I add manually stay on the same row as the data it is initially entered next to?
For example:
<TBODY>
</TBODY>
If I then refresh the query, the manually entered data '23' stays in the same cell, rather than staying in the same row as 'Fred':
<TBODY>
</TBODY>
Is there a solution to this?
Phil.
However when I have tried this I have noticed that when extra rows are added to the table the manually entered data does not stay on the same row as that data it was entered against.<o></o>
Is there a way to make the data I add manually stay on the same row as the data it is initially entered next to?
For example:
Reference Number | Name | age |
[from query] | [from query] | [manually entered] |
003 | Bill | |
002 | Fred | 23 |
001 | Betty |
<TBODY>
</TBODY>
If I then refresh the query, the manually entered data '23' stays in the same cell, rather than staying in the same row as 'Fred':
Reference Number | Name | age |
[from query] | [from query] | [manually entered] |
004 | Geoff | |
003 | Bill | 23 |
002 | Fred | |
001 | Betty |
<TBODY>
</TBODY>
Is there a solution to this?
Phil.