Re: Query ti list records that have been modified
From: Bill Taylor (wtaylor51537_at_earthlink.net)
Date: 04/29/04
- Next message: zooeyhall: "Queries and reports run slow"
- Previous message: Bill Taylor: "Re: SQL Statement"
- In reply to: Daniel P: "Query ti list records that have been modified"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 20:00:04 GMT
Access has an Unmatched query wizard. Select F-11 and Query on the left, now
select New from the top of the object view screen. Then select the choice
Unmatched and follow the wizard.
HTH
"Daniel P" <anonymous@discussions.microsoft.com> wrote in message
news:36686CEA-4E37-4509-93AA-5932DE3F4B2D@microsoft.com...
> Good morning,
>
> I want to create a query that will compare two table with the same
structure to identify which records have been modified.
>
> Let say I have a first table with the folowing columns (Drawing ID -Can be
listed many times,Start Date, End Date, Official's Name) and I have a second
table with the exact same structure (just the data that may be different).
How would I create a query that would verify which records have been change
base on the first table?
>
> Thank you for your help,
>
> Daniel
- Next message: zooeyhall: "Queries and reports run slow"
- Previous message: Bill Taylor: "Re: SQL Statement"
- In reply to: Daniel P: "Query ti list records that have been modified"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
