how to insert from a query to a table when the query is changed

[mana]

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

 

[GohDiamond]

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

INSERT INTO DestinationTableNAME ( destinationFieldNAME1, destinationFieldNAME2) IN 'PATH TO EXTERNAL TABLE'
SELECT SOURCETABLENAME.ID_count, SOURCETABLENAME.Area
FROM SOURCETABLENAME;​

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