I'm fairly experienced with VB, but I'm totally new to CR, so please bear with me.

 

I have two tables, tblCustomers and tblVisitDate. The CustID field is a unique key in tblCustomers. The CustID field is used to identify the customer in each entry in the tblVisitDate table.

I want to select only the customer records in tblCustomers that have an entry in tblVisitDate matching a specific criteria. Also, I only want to select that record one time (I'm printing mailing labels).

I can perform this function in SQL using the IN and WITH keywords, but I don't know where to start with the CR selection formulas. Any help is appreciated- plus I would also appreciate a link to some online resources that explain how to write formulas.

Thanks in advance!

 

Thanks very much for your help on this- your information on how to ensure that only one record is printed will be extremelyt valuable to me long term, also.

 

I have a follow up question concerning this, but I'm going to post it in its own thread since its fairly off topic.

 

Thanks again!