Hi, 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. I
would like to create a worksheet that lists the client name / address (
from the 'Personal' file ) and certain fields from each of the other
files ( eg date_last_visited / last order / sale value etc ). I have
run MS Query but this returns only clients who meet ALL
criteria......some clients would have a blank value in some fields and
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...........hope this makes
sense.......question, is this possible and how do I do it.

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