query, add and update......help

[martinpratt]

Hi,

I am running a query on a linked table. With the result I want to add a column of info (persons name), so I can run a report based on theat name.

I did and update query to a table, added the 'name', but when I re-run the update query to get new info, it just added all the same info again.

Can someone explain the route I should go, to query link table, add persons name to the each result (different names) and then be able to update the info without losing the added names or creating duplicated entries.



cheers

Martin

 

[plog]

Where are you getting the names from and how do you know which name goes with which record in the linked table?

 

[jdraw]

I agree with plog that you have not given sufficient information for us to advise/suggest anything.

Show us your table structure, show the UPDATE query you used, and tell us specifically what you want as a result.

 

[martinpratt]

So sorry for the delay in responding, I have been completely side tracked recently.

The names are coming from a separate table and will be manually assigned.

The query result is a list of jobs and I want to allocate a name to each one and then run report for each name.

I now have a working system, but not sure weather it is over complicated.

I run a standard query on the linked table to gather the list of jobs.

I then run a 'Find Unmatched Query' on the first query against a new empty table [which matches the linked table setup + new column for persons name]. This show the differences between the linked table and the fixed table

Then a third 'Append Query' which updates the fixed table with the results of the 'find unmatched' query.

Now I use a form button to run the append query and show me the results so I can assign a name.

phew, it seems to work quite nicely, just sounds a bit long winded. I thought perhaps you could do all this in just one query, but running a single append query just keeps adding the same list of jobs from the linked table to the fixed table.

Still if anyone thinks there is a better way, then I'll look at it, but for now it seems to work

Thanks to you all, Martin