S
Santa-D
I have a table that contains significant information regarding a large
number of assets (Vehicles). I get a series of external data from two
suppliers and rather that running a delete query and transfer
spreadsheet macro I'm wanting to modify the existing data and change it
to the new data, if there is no existing data import as new and if
there are records with no new data then change the reorder status to 9.
I import a report from the Fleet Management Company which doesn't
include a list of sold vehicles, but I do get a list from the Finance
Company which identifies which vehicles are sold but that may be just
as hard as If there is no existing record in table B and it exists in
table A then vehicle must be sold and convert status symbol to 9.
Is there a way that I can do this? I was thinking of running an update
query but I couldn't quite figure it out. Any suggestions would be
gratefully accepted.
number of assets (Vehicles). I get a series of external data from two
suppliers and rather that running a delete query and transfer
spreadsheet macro I'm wanting to modify the existing data and change it
to the new data, if there is no existing data import as new and if
there are records with no new data then change the reorder status to 9.
I import a report from the Fleet Management Company which doesn't
include a list of sold vehicles, but I do get a list from the Finance
Company which identifies which vehicles are sold but that may be just
as hard as If there is no existing record in table B and it exists in
table A then vehicle must be sold and convert status symbol to 9.
Is there a way that I can do this? I was thinking of running an update
query but I couldn't quite figure it out. Any suggestions would be
gratefully accepted.