Sorry to post again, but 24 hours on with no response to my initial
post, I think it unlikely to now be read.........may I ask again with a
little more explaination.... any help appreciated.

I have 7 foxpro database files that each contains specific information
about clients. One database (personal) contains the client personal
detail whilst the other files are referenced by the unique client_ID
and contain clinical information about the 'clients'.

I would like to create a worksheet that lists all the client name /
address (
from the 'Personal' file ) and certain fields from each of the other
files. Simply put, each of the other files contain details of the
'clients' medical conditions.....asthma/heart disease/diabetes etc. I
need to pull this information together into one worksheet to show the
condition(s) each client has.....ie who has more than one condition. I
haverun MS Query but this returns only clients who meet ALL
criteria......some clients would have a blank value in some fields
where they don't have the condition, these then are not included in the
returned worksheet...........I am looking to end up with every client
listed and with blank cells if there is no data within that field value
ie no condition existing...........hope this makes
sense.......question, is this possible and how do I do it.

many thanks...........