Search results

I have a combo box (ICUAdmittingDx) that has a table (AdmittingDxtbl) for row source. There is a text box (AdmDxOther) on the form that needs to be filled in when specific items are selected from the combo box. There are 13 of these out of a total of 86. I would like to have a message box appear...

I have a database used for tracking patient eligibility for studies. I have a table that stores all the patient’s data that needs to be recorded, a table that stores the eligibility information for all studies on each patient, and a lookup table that lists the studies currently being conducted...

Thanks very much Pat. I seem to be always trying to make things too difficult. I struggled a lot with it. When you pointed out the And before Or rule (which I did not know) it became very clear. Thanks again.

Hello, I'm having trouble trying to adjust a report in which I use IIf statements. I have a database that tracks all the major joint replacement surgeries done. (Total hip replacment, total knee replacement, etc.) In my report, the various surgeries are total for a defined time period which is...

I apologize if I'm a little thick. Does that not require manual input to add a new record (month) in the table every time there is data entered for that month? I was looking for code to create the list.

I have found many posts on this subject, but can't find the answer I'm looking for. I would like to create a form requiring user input to generate a monthly report. I have used the calendars often and they work great, but, what I would really like this time is just a form where the user would...

I did a search and didn't find the previous post. It didn't occur to me to create an additional table to define the ranges. Looking at it, I think that will do the trick. Thanks so much for your help.

Hi. I have a database where an admission date and a discharge date are entered on a form. From this I calculate the Length of stay. What I'm having trouble with is creating a query that calculates how many have a Length of stay of less than seven days, 8 - 10 days, 11-14 and >14, along with the...