Search results

@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...

Yes, I typed in the SQL originally, my concern is that end users will mess it up once my application is deployed. All it takes is opening and saving in design view. Why can't access just do this? Where condition1 AND condition 2 AND . . . AND (Condition A Or Condition B OR . . .) instead...

I have a big messy query, it looks like this: (about 1200 characters with 10 AND/OR statements) 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 &...

That's exactly what I was thinking about since the function isn't always caleld from the form that has the focus. Thanks for the link.

Yeah, I can do that. It is a lot simpler, but not nearly as crafty. If anyone wants to make a mountain out of a molehill, I'm still curious. In addition to the details above, one of the forms has quite a few subforms with subforms. I was trying find a different approach to puting in...

I have a public function, Foobar, in a module that can be called from FormA, FormB, or FormC. Each of these forms contains a field we'll call Output. The output of Foobar is in part determined by where the function was called from. I.E. Public Function Foobar (arg1, arg2) if...