General query: adding tables in 'design view' changing field values

[harshadborde]

Hello Friends,

I am new to access. I have 'table A' in which there 'A11' is calculated field. I want to join 'Table A' with 'Table B'. When I am putting 'B' in design view, even with joining B to A, value of 'A11' is changing after running query.



Why does it happen?

[CJ_London]

depends on what the query does and the calculated field does

[harshadborde]

depends on what the query does and the calculated field does

Query is just to calculate sum of calculated filed (A11). That field is not related to other table, still value of sum is coming different before and after putting table B in design view.

[CJ_London]

so it is the sum value that is changing, not the calculated field? If so then then it is most likely that table B has 2 or more records which match the same record in table A