Finding unmatched funding

[rcollins]

I have two tables that I am working on here, tblClientContact and tblClientFunding. I made a query from tblClientFunding that pulls out only the current funding available. I need to match this up with the funding in the tblClientContact. I thought I could do this with the unmatched query wizard, am I wrong?

[puppydogbuddy]

You should be able to if you complete the prescribed steps properly, and provide for nulls. Are you having a problem? Please provide more details.

[rcollins]

So, their finding is imputted into a table, tblFunding. They can have Comp, Medicaid, State, DVR, ect. They use palm pilots with spreadsheets that I gather up and import their contact info. On the spreadsheets, they fill out what funding they have, and are not always correct. After I do the import, I would like to compare the data now in the tblClient Contact with the real funding in tblFunding. When I run the query, I should have one record come back as unmatched, but it doesn't. Does it have to be null values or can you compare the tables too see if, for example, first table has comp and second table has dvr. This would be wrong as far as what we are looking for.

[puppydogbuddy]

[color=black]The unmatched query wizard should work. [/color]

[color=black]Did you have a common field like "funding Source" that you used as a basis for determining the "unmatched"?. Did you create a join on that field while using the wizard?[/color]

[color=black]Try the step by step shown in this link and see if it helps:[/color]

[color=black] [/color]

[color=black] [color=#800080]http://www.fabalou.com/access/Queries/isnullquery.asp[/color][/color]