how to insert from a query to a table when the query is changed (1 Viewer)

Hello

i work with access web database. in access web aggregate functions are disabled in query design. so i made a query in client and i thought then i can insert this data to another web table. but i don't know how to update this table. because the source tbale of the query is also updated. do you have any ideas?
i upload the database with a table in it and a query.
i want to add the data of this query to another web table
thank you

Using logic that applies to appending data to tables in external databases, perhaps it goes something like this:


DestinationtableNAME is probably the name of the webtable
DestinationFieldNAME1 is likely the name of the webtable.field


Your path to the external table would be in a string like:
(ex: 'C:\Users\username\Desktop\Test_Folder\TEST.accdb')
if it's not on your computer then it'll be a webURL to the WebTable I guess.

I hope this helps some. I don't deal with webapps yet but they probably have similar structures to desktop applications and FE/BE applications created with Access.

Good Luck,
Cheers!
Goh