Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can this be done ??
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........... |
#2
|
|||
|
|||
This could be a Foxpro question about which I know nothing. The first question in reply is can Foxpro export all of its data by way of a .csv or .txt file? If so, then you could open these in Excel, and correctly columnise the entries, then use VLookup from the first (Personal) sheet to add data from other sheets into the required columns. Then Copy that worksheet and Paste Special, Values to a new worksheet. There are other ways to join worksheets, but this one provides simple-to-check processing for each step. Mike Wrote: 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........... -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395481 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|