Recent content by Indi123

Hi VbaInet - thanks for the reply and I am glad that you are still helping me In the count/total query this is what I put under Referral date column >=DateAdd("m",-6,Date()) For example, It counted How many times Mt Smith had visited the health clinic during last 6 months. Two...

Some positive update. I managed to get what I needed within the query Now My query says: Patient ID.................Referrals within Last 3 months 01...................................... 05 04...................................... 02...

hi VbaInet and others Thanks so much for your reply. As you can see clearly, I don't understand step4 The first time I knew, that there is something called "Access" in my Ms Office pack ...was the day I registered with this forum. So guys, any simple step for you...is a VERY...

Hi VbaInet and Co It looks like I jumped in the air too quick Ok this is what happening .. I could not get the DateDiff to work.. (did I hear you said Idiot ...lol no worries) However I used this expression >=DateAdd("m",-4,Date()) so this kind of did what I needed (not sure...

I just managed to get it going - thanks for now, but I am sure I will need yours and others help later on

sorry to be a pain, will you be able to kindly post the that Datediff criteria (how to write the criteria)

Hi Gina, Thanks so much for your support and the offer. I discarded my original Four table idea and moved on with Two table Db. I promised my admin guys that I was going to give them an easier tool to collected data and that was three months ago so can’t delay my promise lol (I had...

Hi Ginawhipp, thanks so much Now you know the depth of my access knowledge – lol In fact I originally had 4 tables (1) Patient info (2) Referral Info (3) Assessment info (4) Discharge info Then I put this idea to this forum and the advised was – too many tables cut it down two So I kept Pt...

Thanks so much for the rapid response. pls Be kind to me when you advise - as I have no previous knowledge of Access or Dbs I think, reflecting on my post I haven’t made things clear for what I need. I have two tables (1) Patient info (2) Referral Info One patient can have many visits to the...

Thanks for your reply Just to keep you in picture, I am only a clinician who is pretending to be DB designer, so when you asked me about Source etc … it is bit of a strange language. However, I assumed you asked me, how does “Referral reasons” link to the table ?? Out of the two tables, one is...

Hi All I have two tables access DB Table one – Patients’ bio data Table two – Referral Data Referral table collects data such as – date of referral, time Reason/s for referral etc I created One to many relationship – as same pt can get referred many times over months and years...

Hi All I have two tables access DB Table one – Patients’ bio data Table two – Referral Data Referral table collects data such as – date of referral, time, Reason/s for referral etc I created One to many relationship – as same pt can get referred many times over months and years. Based...

Hi all Thanks for reply My Access knowledge is just above Zero lol Forms row source ... I assume you are asking where does the form get information from ?? I have two table database (1) Patient Info Table (2) Referral Info Table One of the field in Referral table is called...

Hi GinaWhipp Thanks for your reply. Only one picture (In my referral Table, I have a field called Diagnosis: for this I have lookup box facility, one of the diagnosis is Dementia. So if user happened to tick Dementia as one of the diagnosis - then I want the form to display a butterfly)...

Hi Guys, I have a subform with Referral dates of my patients. At present it looks like this: Referral Date 11/06/14 16/06/14 30/06/14 (Most newest referral at the bottom) What I want: I want the most Newest referral to stay on top Any advice please Thanks