Recent content by hollyh

Hello, sorry I did not see your reply! none of these fields are mandatory so there are mostly primary dx's but not all the time and half the time there are secondar dx's no third dx

t so I am working on a database which was set up wrong. currently they have a floating table with zero relationships called diagnosis. they use this table in a query, to get the TEXT of the primary dx and secondary dx in a VIST table. so there's 3 tables, but really only two being used...

nm, figured it out.

i have been usign wizards to do this so bare with me, newbie I have a crosstab query based off another query and I would like to add "CHF" to each column, is there any easy way to do this? so it would look like "1st Trimester"+CHF here's the code TRANSFORM...

i am dyslexic i must've typed something wrong it works. thanks

text yes no don't know in a drop down box

Okay sorry I figured something out The person who made the database (not me) created a main table with a column SMOKING linking to a query of another table called YNDK with ID autonumber, then yes..no..don't know I would like to convert these values to either 2 for yes or 1 for no or...

this isnt working, maybe because its a calculated field

Hi Sorry, I'm confused. this is not for a report but for a query..can you do it in the query?

thanks!! :)

so I am trying to calculate BMI so far I have this BMI: 703*[Weightlbs]/[Height]^2 and it works! however, I would like it to only show one or two decimal places. the ROUND statement is rounding to whole numbers is this possible?

Okay so I am trying to run a query where the row source on a table references another query of a table with the categories, yes, no, don't know i would like to convert these to a numerical value in a new query, iif statements do not work. am i missing something obvious :o thanks.

Okay so this isn't even pretending to work SELECT subquery_Analysis_PrePregMedications.ID, subquery_Analysis_PrePregMedications.[Visit Type], subquery_Analysis_PrePregMedications.BetaBlocker, subquery_Analysis_PrePregMedications.Diuretic, subquery_Analysis_PrePregMedications.Anticoagulation...

so it turns out there are some drugs that need to be lumped together to create a new value for example Diuretic: IIf(([Diuretic1]=True Or [Diuretic2]=True),1,0) I made a bunch of subqueries where the criteria is 1st Trimester, 2nd etc.. and I am trying now to just join all the subqueries in...

actually, i get it..sort of, one query that shows the number values is based on IIF statements what I don't get is these fields have null values too so why on earth would they use a check box i see how to change it to yes/no on the table but id still rather have a number without screwing up...