Search results

So I met with another pier with regards to the different sources of information. Going to wait until I get out of a few meetings today to determine what lists are actually going to get compared lol.

Unmatched Old Query SELECT [IIS Master Old 11 20 2013].Field1, [IIS ****** 11-20-2013].Field1 FROM [IIS Master Old 11 20 2013] LEFT JOIN [IIS ****** 11-20-2013] ON [IIS Master Old 11 20 2013].Field1=[IIS ****** 11-20-2013].Field1 WHERE ((([IIS ****** 11-20-2013].Field1) Is Null)); ****** has...

The combine query - no - I have a meeting today with one of the engineers who works with the IPs that I tested this morning. See the challenge is that there's no single source of truth. I'm going to work with him to see what information he has and run that through the queries as well to find...

Well I've run the individual queries for Old and New on actual data and it seems fairly accurate. I like the fact that I have two separate queries running for each question individually. Management does like to look at both sides individually as well as combined; and, combining the information...

Sounds good - heading out - will hit this back up when I get in tomorrow EST time zone.

Lol - still didn't work. Loops on asking me for parameter type. I have to head off to the docs so going to eat quick lunch and then head out. Thanks for the help this afternoon both of you. Will be back on tomorrow...will PM when on if that's okay?

The specified field '[UnmatchedOld].[Field1]' could refer to more than one table listed in the FROM clause of your SQL statement.

David, Here's the UnmatchedOld query code: SELECT [Test Table 1].Field1, [Test Table 2].Field1 FROM [Test Table 1] LEFT JOIN [Test Table 2] ON [Test Table 1].Field1 = [Test Table 2].Field1 WHERE ((([Test Table 2].Field1) Is Null));

I'm thinking that keeping them in their own queries is cool. I have no problem with that due to the fact that I'm probably going to get report requests based on one or both of the criteria; so, having one query per is cool. I need to do some design work around how I want the end state to look...

David - Here's what i have that seems to run but it asks me for parameters when I run it? SELECT [UnmatchedOld].[Test Table 1], "oldIP" AS Source FROM [UnmatchedOld] UNION SELECT [UnmatchedNew].[Test Table 2], "newIP" AS Source FROM [UnmatchedNew];

Also - once i get this all squared away I'm going to want to make a new master list...

plog - I ran your idea two different ways and it worked just great. I'm going to test david's code and see how that falls out. So far making progress =). Yea!!

Thanks you two - I'm going to try both of these now =). As far as experience goes I haven't used Access since my intro to Windows Apps in college about 5 years ago lol. Most of my experience is with Security and Network apps.

Ok - please bear in mind that I AM NOT A SQL PROGRAMMER lol. However, that being said I have been charged with learning enough Access to make me mildly dangerous. I am trying to compare two tables and find the differences; and, no - what the Query Wizard has to offer is not what I'm looking...