Search results

anyone? i was hoping the picture would clarify my problem enough that someone advanced could help me out quickly

hey there i have a main PatientForm that contains patient information from multiple tables: [GENERAL] values Subform - [RefMD] values (referring doctor) Subform - [Drugs] values (prescribed meds) Subform - [Diagnosis] values (medical diagnosis) Subform - [Encounters] values (visits to the...

thanks for all your help guys, i figured it out.. turns out, it was selecting the top 5 of ALL the records, and nothing came up because the records that i was testing with were not part of those top 5. what i needed to do is use WHERE Encount.HistNum = the filtered record.. thanks

i was told that in order to select the record where Type = "Clinic-New" and the most recent 5 records using the Date field, i should create a union query using top.. am i headed in the right direction?

well, there will only be one Clinic-New for each patient (and the report is filtered to 1 patient at a time).. so i know that isnt right. however, the TOP 5 still doesn't work. it is either in and only shows Clinic-New records, or out and shows all

can anyone help me? its real important for me

hey there, i figured out that my problem was not what i previously thought it was.. i needed to change my record source rather than try to filter my report. thanks to the user who suggested this.. right now, this is the record source i have for my report Encounters. SELECT ENCOUNT.* FROM...

this report is filtered to 1 patient at a time. what i want to do is display the Clinic-New value first (because there is only 1 time you can visit the doctor and it be a "new" visit), and from then on, select the last 5 visits using the Date field. how do i format this to work then? because i...

why would i index ENCOUNT.Type? it is only the value of the type of visit (i.e. Clinic-New for the first visit). i guess i am really mixed up here in my head. can someone redirect me in the direction of what i said i wanted in the first post?

i keep getting syntax errors using TOP

well i tried this, and it doesnt work. once i get the selection right, i still need to know how to limit the results to 1 or to 5 or 6. where do i place this query when its finished too, because it doesnt work in the Filter property of my Encounters report. SELECT ENCOUNT.Type FROM ENCOUNT...

my bad there is an indexed ID column that is AutoNumber which is what i was referring to when i said in order ive been informed that if i am unable to get it to do the Clinic-New records and the last 5, then i can just do the last 6 instead.. but i would like to try the first idea. any idea?

well i work with PHP too (and that is correct in php/mysql webwork), and it may not be 100% the same. mind helping me on my problem?

each record is dated in "30-Jan-06" a format like that, DD-Month-YY.. and even then, they are in order, because each day it is updated with the visits from that day. and yes, i do know the SQL syntax, like "SELECT * FROM table ORDER BY field LIMIT 5 ASC", but that doesn't seem to work here...

hah, now that i have my report working, i need to limit one of the subreports.. i have a subreport called ENCOUNT, for encounters (or visits) to the doctor. in this subreport, there are the fields Date, ClinicType, and Notes. what i need to do is limit the number of rows that are displayed to...

wow it was a really strange problem that was stopping it from working.. a textbox with the value "=[GENERAL.HistNum]" instead of "=[HistNum]" stopped everything else on the report from working.. thanks for your help

all the records are linked by their history number. these numbers are 7 digits. for example.. Patient A has the number 1234567 in the GENERAL table, all their personal information is kept. in Diagnosis, their diagnosis of Disease A is stored along with some other information using HistNum. in...

everything i have so far works fine except for the checkboxes that are representing a subform on the main patient form. my table layout is: GENERAL (main form source) displays all the general information on PatientForm DIAGNOSIS (subform) displays all the information on the patient's...

all the tables are related by a history number that is unique to each medical patient. (HistNum) yes, i have tried with just 1 subreport and it works. that wouldnt make a difference would it?

can anyone help me out? here is what i have as the event on my mini form submit button right now.. i havent finished, but the first 2 are checkboxes are part of the GENERAL table and i have done 1 from the DRUGS1 table, checkbox named Medication. acForm = "PatientForm" acFilter = "SELECT...