In my Access 2007 data base i have a field that pertains to number of days that were avoidable. I also have a field that have causes for the avoidable days. These fiels are multi value fields. I am trying to count the numer of times a certain field was documented as a cause, but not the...
I know the title sounds weird. Here is my problem. I have been asked to create a form for data entry. There are 7 questions that they want to have multiple answers they can check. These answers are set answers. Each question has upwards to 14 answers available. I have made a table with the...
You make a query off the table, in the query you concanate the three fields you were talking about into a new field with the name you choose. You can place a [Enter] statement into the criteria of any field you want to filter the report on and use this query as the report control source. I...
I hail from Kansas City Missouri. I work for a major hospital abstracting Core Measure Data and submitting it to the Center for Medicare Services. I guess you would call me a data analyst but my beginning started in basic with the comadore 64. LOL. Fortran and cobalt in College and then...