2. In the upper pane of query design, drag Field1 from Table1, and drop it
on the matching field in Table2. Access shows a line joining the 2 tables.
3. Drag the 2nd field from both tables into the grid.
In the Critiera row under Balance from Table1, enter:
<> [Table2].[Balance]
The query now shows the matching fields (because of the joins at step 2)
where the balances are different (because of the criteria at step 3.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
"ljp1215" <ljp1215@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BC0A5AF0-A1DF-4C46-B2DC-8C4DDC06D737@xxxxxxxxxxxxxxxx >I have 2 tables that contain the same fields.
>
> I would like to get data back where Field 1 in table 1 and 2 (Account #)
> are
> are the same but in Field 2 ($ Balance) it is different.
Re: Adding fields to existing table from another table ... There is matching field in both tables ... I thought I could do a make-table query but I realized that those ... If you want to see the address information in Table2... in conjunction with the other information in Table1,... (microsoft.public.access.gettingstarted)
Re: Displaying row no/Record Counting ...EnteredOn Date/Time when the record was added. ... You create a query that contains Table1.... On each row of your query, you need to count the number of records in Table1 ... In> order to generate an alphabetical listing of these people,> I have to analyze the report in Excel and sort the> spreadsheet based on the client's name. ... (microsoft.public.access.queries)
Re: Non-updateable query issue ... You have an unnormalized table (of course, as it came from a flat spreadsheet instead of a relational source), and is it has 100 columns. ... joined to the master, showing all the records, the query is not updateable. ... > Say Fred deletes record 79 from Table1, and then Betty changes the> phone ... > Allen Browne - Microsoft MVP.... (microsoft.public.access.queries)
Re: Non-updateable query issue ...Microsoft Access MVP... When putting together that query,..."Duane Hookom" wrote: ... Say Fred deletes record 79 from Table1,... (microsoft.public.access.queries)
