Recent content by kballing

@smig, I guess you're right, there's no reason I can't set N/a to be 0. That's what I'll do. Still, if anyone can shed some light on this, I'm still curious as to why you can't make null a selectable option, or at least some suggestions for my particular circumstance.

no. not required. I've done the same thing with other combo boxes without a problem. I just can't figure out what's different.

I have a form with many combo boxes that correspond to various answers for a survey. The fields are integers that correspond to various answers. e.g. 1; "very good"; 2; "good"; 3, "fair"; 4; "poor"; null, "N/A" I have the row source as shown above. (however not all combo boxes have the same...

Suppose I have 5 stages of development of a product. There are a lot of factors that go into determining when a certain stage is complete and they do not have to happen in any particular order. I don't have fields in my table representing each stage, however I can use one field, STATUS, to...

yeah, that's it, except you'd actually want to do admit date/time + 24-admit time and dishcarge date/time - discharge time, and if you'r going to do that, you'd might as well just use the date only.

I don't remember why I included the +1 and -1, I wasn't concentrating very hard when I replied.

Yes, that is the very simple solution I was looking for. However, just after I posted, I had a Eureka! moment and I came up with the same solution on my own. :cool: I've done this before, I guess I was having a brain fart. I sat in front of my computer for 12 hours thinking up extremely...

Im working with a database of heart transplant catheter procedures on patients. I'm trying to get the exam information for a number of patients from their exam closest to a given date. When a patient comes in for a regular checkup, they usually have a cath procedure done that day, but...

I think I've got an idea that might work I did something similar with patient lab results once. first, heres a link that explains the concept: http://www.access-programmers.co.uk/forums/showthread.php?t=185371 Ok, create a dummy table with all the dates you are interested in, we'll call it...

I'll mess around with things for a while, but I may have questions later so please check back in a while.

Brian, Craig, thanks for the quick replies. What you've said makes sense, but I think the underlying problem is that I need a result from each type of lab, however the dates for each lab are not related. Your solutions would work if I were to run a query for each type of lab and then compile the...

I'll take a stab at answering my own post. I know how to separate different lab types using an if statement (actually it's an Oracle DB so it's a Decode statement). This gives me a table with all the columns that I need, but there are multiple records for the same patient and each lab result is...

I'm pulling lab values from a hospital DB. They are stored in a table like this. Table: LABS Columns: LAB_ID, PATIENT_ID, LAB_TYPE, DATE, RESULT, UNITS Example: 123456, 654321, "WBC", 1/1/2000, 10.2, "K/uL" I have a list of PATIENT_IDs and certain LAB_TYPES from certain dates that I want to...

Here's what my final query looks like. SELECT Patients.EMPI, Patients.LAST_NM & ", " & Patients.FIRST_NM & " " & Patients.MIDDLE_NM AS PAT_NM, DateDiff("yyyy",BIRTH_DT,Date()) AS AGE, Patients.SEX_CD, Providers.LAST_NM & ", " & Providers.FIRST_NM & " " & Providers.MIDDLE_NM AS PRVDR_NM FROM...

Thanks for the suggestions. I'll do what I can to revise things. Some more details: Can't use a wildcard in PCP_ID or SCP_ID, because some ID numbers are included in others. e.g. *123* also gives 123XX, XX123. PCP (primary care provider), SCP (secondary care provider). The user selects a...