Search results

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

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

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.

I inherited a database and I'm new so bare with me The database uses a lot of check boxes when i query one table the check boxes come back as -1 or 0 or blank when i query another table the check boxes show up in the actual query results (annoying) is there a way to disable the check boxes...

i am not sure how to describe this so bare with me basically i have a VISIT TABLE with VisitID PatientID VisitType (1st Trimester, 2ndTrimester, etc) and then columns pertaining to the visit We are trying to do a longitudinal study where we compare each visit type data to itself...