Asset Database

[Guest]

I am working in an asset database. When I dispose of assets I want it to
pre-load information into Excel spreadsheet and then go back and update the
record in access to say disposal submitted. Can anyone help?

 

[John Nurick]

Hi Julie,

Basically, set up two queries: one that selects the records relating to
the items to be disposed of, and one that updates them as needed.

Export the first query to Excel, and then run the second query to update
the records.