Search results

Thanks! I tried it and it worked! One more twist: How can I display in the final query all of the following four fields?: ID Number TotalAmount TotalRepayment Balance When I try to add the TotalAmount and TotalRepayment fields, the same issue occurs. SELECT subAmounts.[ID Number]...

Hi. I am nearly positive I'm not asking this question in the most efficient method possible, so any advice is welcome! I'm new to Access and am not a programmer (as is obvious). Basically: 1. I have two tables: Table1 and Table2 2. Table1 has two fields: ID Number and Amount 3. Table2 has two...