Search results

I cheated and got it working What I have done is in violation of what the senior members keep writing - not inserting calculated values into a table, when the data could remain in queries and be recalculated as needed. I calculated the value in the open main form that has the two subforms open...

its all going into the same report The problem is the final report is a listing of all active patients and for each patient, based on what you have chosen in the parent record, the pertinent date is listed - either Hospital Day# for those not operated or Postop day# for those who have been...

One or the other Yes, the report is to show hospital day or postop day, but not a mix of the two. I have written a function to do this - it takes in operation date, admit date, and the user's choice for what they want on the list, and it returns a text value with either HD__ or POD___. This...

Basic dbase structure - each record has two subforms that could contain either a variable number of hospital admissions (each with an admission date) or a variable number of medical procedures (each with an operation date). In printing an active list of patient records the user will choose...

I have written a small function that accepts two dates and a string, and returns a string. If one of the dates is null, no matter what the other one is or what I do in the body of the function, the function returns '#Erreur' - regardless of if I check with 'IsNull', even if the routine never...