Find Unmatched Records Using Code In Access

[BenSC]

Hi All,
I have two tables [tblProject] and [tblLetter] with a one to many relationship between them. When a letter is sent for a project a record is created in [tblLetter], but if a letter has not yet been sent then there is no record in [tblLetter] for the project.
I have a form with combo boxes that are used to filter a report on different critera. In this case I want to filter the report for all projects where a letter hasn't been sent. This would be easy if I could use a simple find unmatched query, but this has to be able to be used in conjunction with other criteria.
This is a sample of the code, which I'm using:

If Me.comboCriteriaContributionLetter.Value = "Not Sent" Then
If Len(strSQL) > 0 Then
strSQL = strSQL & " AND " & "[Criteria]"
Else
strSQL = "[Criteria]"
End If
Else
End If

Any help on this would be much appreciated

Thanks

Ben Cooper

 

[BrainB]

In similar cases in the past I have used one of these methods :-

1. Check for a blank field in the joined data.
2. Create a special field (eg. LetterSent Y or N)
3. Search the (Letter) table first.




Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================

 

[BenSC]

Thanks for the feedback BrianB. I've decided to just create a blank letter record for each project to get round this problem. It's not good practice, but with proper management it shouldn't be a problem.

Regards
Ben Cooper