Updating a table based upon a current query update

[bearcub]

I hope I'm asking this the way. Bottom line is that I want to update a table because the query data includes information that is missing from the underlying GL table.

Is it possible to update a table from a YTD query coming from Hyperion? I work at Stanford University and they download a monthly report from hyperion and bring it into Access to export to Excel for their variance analysis. It seems that GL accounts, descriptions, new donors, etc, are not being included in the underlying tables which results in unmapped revenues and expenses. I was wondering if I could create a macro to update the tables with items that were in the query (from Hyperion) and were missing from the tables. Or, can I somehow link these to the actual tables so the table can be refreshed on a monthly basis.

Thank you
Michael

 

[Joe4]

Yes, you should be able to do that, provided both tables are able to be linked accurately, so you can tie wants needs to be updated to the specific records that need updating.

Of course, in order to be able to help you with that, we would need a lot more of the details of the actual tables and data.

 

[bearcub]

Thank you Joe

That sounds great! I know the CFO will be thrilled!


The thought occurred to that perhaps I would create an query that is shows displays what is in the query but is missing from each of the two tables. The query is coming from our accounting system and all the grants field combinations (i.e. project name, ID, activity, account description) that is displayed in the query has to be added to the tables. Otherwise we have revenues and expenses that are not being put in the right bucket - they are "unmatched" .

If I have this new query that shows the information that needs to be added to a particular field (in one table I need to add 7 fields of data from the query) I can create an update query with this missing information. I was wondering if I could attach a macro for this update query and add it to the other original macro that runs to import the data into Access initially?

If this is possible, what information do I need to share with on the forum so you can guide me to get this task accomplished?


Michael