I have A, B two tables, all field properties are the same, the two table data from C table using the query group, now aims to do every month installation summary statistics, but some installation is done two or three people together, want to install more than the number of split out to everyone in the installation data,
B table A field is A person's name, A field is the name of the two people add A table/together, containing the B table A field name, I'm going to put A table field contains B table A field name of the record of all values divided by 2, and table B existing value addition, the corresponding field in two tables of contents such as the following figure, this how to do it, A great god please help solve, thank you very much!