I need a quick excel macro that would get data from an access query, and then update the data in excel where there is a match. The excel data has TAG_NO and MP_NO_E among the columns, and the query returns TAG_NO and MP_NO_A. For each TAG_NO that matches, I want to update MP_NO_E to MP_NO_A.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…