Search results

I have two tables, patients and transfusions. Not all patients are transfused. I want to create one query that will show all patients, regardless if they were transfused. Also, each patient may have more than 1 transfusion event. Pat A Tx 1/1/2016 Pat A Tx 1/2/2016 Pat B Pat C Tx 2/1/2016...

I am doing a Biggest Loser challenge at work and have a nice report that shows the users their weight loss over time. I'd also like to add a table that shows the group's starting weight and the group's current weight. I have one simple weights table that lists the ID of the contestant, the date...

I have a form with a combo box that the user will use to select from a predefined list of data. When I click the drop down the data scrolls to the right and I can't see all of it. If I select one of the items on the list, I can see it in the combo box display. Is there a way to control the...

I want to create what I thought was a simple select query. I have 2 tables. COMPONENTS UNIT_ID COLL_DATE ATTRIBUTES ATTRIB_CODE UNIT_ID The COMPONENTS table lists each item only once, the ATTRIBUTES will have anywhere from no ATTRIB_CODE values to several. Here's and example: COMPONENTS...

I inherited a table with a few simple columns. I want to find all records where the [Patient ID Medical Record Number] are the same AND the [Antibody, Antigen or Special Instruction Code] are the same. The problem is that the [Antibody, Antigen or Special Instruction Code] needs to be case...

I have a form that I want to act somewhat like a Switchboard. If a user has records they need to audit, I want a button to show that they can click on to display the records. If they don't have any records to audit, I want it to say that in text instead. The way i tried to solve it was with an...