By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,061 Members | 1,563 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,061 IT Pros & Developers. It's quick & easy.

Finding unmatched funding

rcollins
100+
P: 234
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?
May 20 '07 #1
Share this Question
Share on Google+
3 Replies


puppydogbuddy
Expert 100+
P: 1,923
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.
May 20 '07 #2

rcollins
100+
P: 234
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.
May 21 '07 #3

puppydogbuddy
Expert 100+
P: 1,923
[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]
May 21 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.