I have a table which contains all order numbers (sord).

This is linked to another table which records the date a letter was sent to the customer (if sent) and what type of letter was sent. (letter)

Sord                                       Letter

order_number                        order_number

           date_letter_sent

                                               letter_type

The linked field is order_number.

 The report currently looks like this:

(Figure a)

I want it to show all order numbers but only show letter types of A.

Like this:

(Figure b)

I tried a record selection to say where letter_type = A

But this gave me the following results:

(Figure c)

What formula can I use to get to figure b?

It works if I use a sub report but I don’t want to do this because I need to be able to group and sort by letter date.

Hope you can help!

Thank you very much.