UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Save Filtered Data Back To Original Table, Office 2010    
 
   
wornout
post Dec 2 2019, 03:21 PM
Post#1



Posts: 1,328
Joined: 17-November 13
From: Orewa New Zealand


I have been searching all morning to find an answer but I can not seem to find one.
I have an advance filter I would like to add/Change data to it and save it back to the original table
so the original table is table2 in Worksheet("all Dates") the filter is in worksheet("DashBoard") The filter goes from columns CF6 to CN it is also a table "Table1" I will be adding to column CN(the header is called Paid) the Word "TRUE" and it will go in Table2 column Q heading is Paid .

Go to the top of the page
 
ranman256
post Yesterday, 06:51 AM
Post#2



Posts: 905
Joined: 25-April 14



If you filter table2, then the changes remain in table2.

If not, run an update query using the same filter on table1.
Go to the top of the page
 
cheekybuddha
post Yesterday, 07:24 AM
Post#3


UtterAccess Moderator
Posts: 11,907
Joined: 6-December 03
From: Telegraph Hill


>> If not, run an update query using the same filter on table1. <<

Excel, not Access

--------------------


Regards,

David Marten
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 09:08 AM