Query Data and adjacent columns

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

OK, how's this... I create a New Database Query (let's say
that it takes up columns A through D on a seperate
worksheet), and I manually add information in columns
adjacent to that query (columns E and F), as I add and
delete items within the original queried database, the new
query will update, but will only adjust line inserts and
deletions within that query... data that has been added
adjacent to the query (columns E & F) remain unchanged. I
would like to know if there is a way to tie manually
inserted data to a query so that the entire row is
affected by the query results.
HELP! and Thanks
 
Don

You have not descibed what you are doing in columns E & F.
I would have thought that the only way you can link the
information in these column is by using a formula.

Perhaps this information should be entered in Access
itself?

Regards
Peter
 
Back
Top