Hi,

I've got a problem with the report I created. It is possible that a client has more then 1 contact person. If this happens, we want to show both of them on the report. In the database, the second contact person is stated by code =7. If it is anything else then 7, it is the first contact, if it is 7 it is the second.

I created a formula, stating that if this code is 7, and the the name is filled in, then I want to show the name. But when I run this formula, I got 2 letters. 1 with only the first contact, and 1 with both contacts. The formula looks like this:

IF{Client.code}=7 AND NOT ISNULL({Contact.firstname}) AND NOT ISNULL({Contact.lastname}) THEN
{Contact.firstname} & Chr (13) & Chr(10) & {Contact.lastname}

But it looks like after the THEN statement, it doesn't look like it is looking at the IF statement. Does anyone know what I mean? And can anyone help me with this?

Thanks in advance

Gerben

Never mind, after working on this again this morning, I found out that the database is set up in a different way then that they told me... so the problem is in the database instead of CR.