validating software compliance (query)...

[Guest]

Ok I am going to try to explain my situation as clearly as I can.

I get a report from an application of all the programs that my users have
installed on there pcs.
I inport it into table A in access.
No I also have a table B that has a list of all the programs by (Product
Manufacture, Product Name, Version Number) that are allowed on the pcs.

Now here is where my problem is.
I want to run a query that compares the data from the imported table A to
the data in Table B and return everything that That is not matched.

The following is the query that I have created which is to best of my
knowledge how to go about this

I have booth tables and I have set three relations between them.
TableA TableB
Product Manufacture---->Product Manufacture
Product Name------------>Product Name
Product Version----------> Product Version
Misc1
Misc2
Misc3...Etc

The three relationsships are all set as option 2 where it includes all
fields from Table A and only thoses that are equal from Bable B

I have added all of the fields from table a and added product version from
table B and for the criteria I put Is Null

I don't know if I have gone about this correctly, but to my logic this
should return the software that is not reconized, however I get an error
"Type Mismatch in experision"


Any guidance or help is much appreciated! Thanks!

 

[Ruth]

The first thing I would check would be the data type of all of the
related fields. It sounds like you might have it assigned as "text" in
one table and "numeric" in another. Since versions can contain alpha
characters as well, I'd go ahead and set the data type to text on
both. The second thing I would check is table B to ensure that you
don't have any nulls in the related fields. If the field is allowed to
contain a null value, I don't think it can be used to establish a
relationship. So either populate it or drop it. Hope this helps!