Unanswered: How do I concatinate 3 fields for FindFirst Criteria
Hi there Access gurus. I need to concatinate 3 strings to be used with FindFirst with in a form. I have gone throuh the help pages with in Access help but still can't figure out how to do it, your help is appreciated.
The criteria would be as follows
Criteria = [Year]=me!xxxxx, [Month]=me!xxxxx, [Week]=me!xxxxx
to be used for rst.FindFirst Criteria
What i need to do is to find a specific record with in a payroll table that matches the criteria and send a meassage if "rst.no match" is false