Re: Query to check data in old and new tables
Short version, you can't. You can create a UNION query that joins the two tables together, or modify the report's record source dynamically.
Microsoft Access MVP 2007-2019
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.