Can this be done............??
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........... |
All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com