Search results

works a treat cheers guys

I have two date/time fields. Date referred Date seen I want to add some validation in it which says If the Date referred entered is greater than the date seen - tell the user to "Date referred cannot be entered as a date greater than the date seen"

thank you guys - thats ueful

I have a table called tblEpisode with a unique if EpisodeID. I have been given an Excel spreadsheet with a list of EpisodeID and follow up comments against each. I have added a new field to tblEpisde called FollowUpComments.I am trying to run query which updates each episode and adds the comments?

As it stands I currently have two tables - tblPatient tblEpisode tblEpisode has data pertaining to treatment that patient was given in an episode But should I break that tblEpisode down even further i.e. Clinicalevent Treatmentoptions Dischargemeds Initialdrugs i have attached current...

I was thinking about reorganizing the table structure as well! Honest. I might do that a) that will work and b)it will normalize the data to a greater extent

If i have a table with most of the fields in ti being list boxes (yes/no) is there any way I can show only the fields with a 'yes' in a report. One of the fields is Discharge_meds_digoxin If the list bix option is 'yes' I want to have in the report 'Digoxin' as opposed to 'yes'? I have...

thank you vbainet those changes have made a positive impact

Have found a cheeky way around this. :-) I have created a query called qryRTT which selects the top 50 percent of the Referral to Treatment values, put them in descending order, then created another query which selects the maximum value of qryRTT.

Hmmm - I tried removing the Avg Min and Max in the query and the wrong result still comes out when choosing the date zone start 01/01/2011 and end 01/02/2011 and for 01/02/2011 and 10/03/2011

I have tested it again by picking the top 50 percent of the records. PARAMETERS [Forms]![frmReport]![startdate] DateTime, [Forms]![frmReport]![enddate] DateTime; SELECT TOP 50 PERCENT qryEpisode.Patient_Name, qryEpisode.EpisodeID, qryEpisode.ReferralToTreatment FROM qryEpisode WHERE...

when the db loads enter andy for username and andy for password click the auditing button on the home page enetr start date 01/01/2011 and end date 01/02/2011 as a test then click 'preview report' next to 'waiting times'

i tell you - i wish i was working outside today!!! its lovely

post no. 49 has db attached

definitely applying the same start and end date criterias in query and in median function try entering 01/01/2011 start date and 01/02/2011 end date you will see - referral to treatment is wrong last db attachment is updated one yes

here are the test results

Just done some more tests using the report as well as testing manually in the query and it appears not to work if there are a odd number of records in the query

forgigve me - new attachment see above

No not quite Awkward to explain so please see attached as demo Logon as andy and password andy The report is in 'auditing' and 'waiting time averages' query is qryWaitingTimesAverages - thats where functions are called to create the medians for the columns ReferalToTreatment and...

Sorry. The queries return depends on the parameters chosen. Monthly reports will return about 50 records