MAX Function problem

[Guest]

Hi,

We've been handed a dump from a database from an external source. The
tables are Customer, Address and Contact Number.

We're trying to produce a report displaying all customers. We only want a
single contact number on the list however when we use MAX function it removes
those customers that do not have contact numbers as well as the additional
numbers.

How can we just have all patients and a single contact number?

Many thanks

Ian

 

[John Spencer]

Three Tables that are linked how?
Can you post the query you are using currently? Perhaps someone can suggest
a modification once they have seen the SQL statement. My best guess without
any information is that your query is using an inner join while it probably
needs to use either a Left Join or a Right Join.

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message