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:[TABLE="width: 500"]
<TBODY>[TR]
[TD]Reference Number[/TD]
[TD]Name[/TD]
[TD]age[/TD]
[/TR]
[TR]
[TD][from query][/TD]
[TD][from query][/TD]
[TD][manually entered][/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD]Bill[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]Fred[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]Betty[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
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':
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Reference Number[/TD]
[TD]Name[/TD]
[TD]age[/TD]
[/TR]
[TR]
[TD][from query][/TD]
[TD][from query][/TD]
[TD][manually entered][/TD]
[/TR]
[TR]
[TD]004[/TD]
[TD]Geoff[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD]Bill[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]Fred[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]Betty[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
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


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:[TABLE="width: 500"]
<TBODY>[TR]
[TD]Reference Number[/TD]
[TD]Name[/TD]
[TD]age[/TD]
[/TR]
[TR]
[TD][from query][/TD]
[TD][from query][/TD]
[TD][manually entered][/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD]Bill[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]Fred[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]Betty[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
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':
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Reference Number[/TD]
[TD]Name[/TD]
[TD]age[/TD]
[/TR]
[TR]
[TD][from query][/TD]
[TD][from query][/TD]
[TD][manually entered][/TD]
[/TR]
[TR]
[TD]004[/TD]
[TD]Geoff[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD]Bill[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]Fred[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]Betty[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
Is there a solution to this?
Phil.