Hi, I'll be happy to help with this issue
This should be possible in Microsoft Access if you have that?
What format is the data in currently?
Let me know and I'll be able to advise further
I will attach a screen shot of the different tables and relationship.
Is it possible that I email you the project and you can determine what it will take to do what I need.
sure - if you e-mail it XXXXX@XXXXXX.XXX and put for my attention along with a link to this chat I can work from there
I can attach the screen shots now and I will email you the whole project
The problem I am having is that I want to create a query that will pull from the demographics table and the third record in the clinical data table. The project has to be limited to two tables for some reason.
ok, I think it should be possible to pull query data from any combination of records
but will work on this when the e-mail comes through
and let you know
I just sent email to your attention, I forgot to put this link in so I will send again.
I do not know the next step from here please advise.
just working on the file - the query required, what values should it pull from each table?
the query needs to pull the initial bp from the demographics table and the bp, bmi from the third record on the clinical data table
I have watched numerous training videos about access and could not figure this out. I can only see how to pull from the first record of the clinical data table. I did not see how to specify the third record.
ok, any sorting/criteria needed?
not that i know of, i am doing this for my wife i will ask her now
no sorting, the only thing she needs is that when the third record is created on any patient the query will pull the bmi and bp from that third record. Is this the best way to make this type of database, In my opinion I do not think so but they are limited to what they can do as far as tables and fields are concerned.
ok so along with the initial bp from demographics table and bp/bmi from clinical data should the patients name also be includeD?
yes the pt name and medical record number (mrn)
you have helped 532 people since january? wow
lol, guess so
although some of them are repeat customers I guess
can you see how Query1 works on this database file?
http://wikisend.com/download/481842/Database to Track the Effectiveness of Lifestyle Modifications for Primary Prevention of Hypertension Edit.accdb
does it have to pull each record or can it be limited to the initial bp and the final bp only
the default is to pull each record
is it difficult to change that or does that require a more intensive approach, i know it will incur additional cost, its how much is the question
That would require some more customization on the query I believe - although I just want to be sure I'm understanding it right
when you say 'does it have to pull each record' - do you mean each row in the Access tables?
yes i mean each row, i am calling them records because of something i watched in a trainsignal video, when information is put into the demographic table, it is creating a new record or row in the clinical data table and i want the query to pull the third row only, the first two rows are not needed for the query
ok - at the moment if I enter some data into the demographic table, it doesn't follow through to the clinical data - have I missed something?
i am not sure, when i input data into the demographics table it did populate to the clinical data table after some time it was not immediate, did i do something wrong
no that's fine, I only did it as a quick test - want to make sure I'm giving you the right advice
the way the query works is only reading certain fields from each table
if you right-click Query1 in Access and choose Design View that should explain it better than I can
my wife said she had to compact database to get information to come up in the clinical data table once entered into the demographics table, i did not know that till now
ok so it can only read certain fields and not be specified to read rows
yes, can be specified to read whatever fields are required
shouldnt it auto populate the fields in the clinical data table, seems to me like i do not have the relationships set up right or something
the query I have put in combines the lastname, firstname fields as well
did you see my last question about the relationships
yes - just checking
what will it take to read the third row for each person that we add from here on
on the query side do you mean?
the query is automatic
and will read the specified rows for any additional person now
ok good deal
in terms of autopopulating you would need to create an Access Form and enter details that way
if relationships are correct it should then propogate automatically to ClinicalData
ok that is one of the requirements as well, i thought it was strange that we had to enter information into the table, i will start on the form and see how that goes, i may need your help on that as well
on the query side I think you're all set
ok what happens next
how do you mean?
the next step in this help process
ah ok - well if you're happy with the service you can rate the answer which credits me. Can add further questions/updates as required on this thread as well without incurring an additional charge
when i submit the rating it says it will close chat, but is there a revised file for the database
it will close the chat but you can use the link still to come back and ask additional questions
Did the link I sent earlier not work? That should have been the revised database file
ok yes it works fine just making sure, thanks for your help, i will get back to you if i need help with the form
let me know if you need anything at all
have a good day and thanks again