Search results

So.. should I create a calculated field on the table or query that tells me if HospitalAdmitDiagnosis = FacilityAdmitDiagnosis, or if they're not the same? (i.e. output of -1 and 0.) Or should I create two separate columns, one that has 1 for yes and 0 for no, the column headings being "Same"...

Hello! I am trying to count how many of the "sames" and "differences", as well as calculate the percentages of the number of "sames" over the total amount. To clarify, I work at a nursing home, and I need to calculate the number of people who were admitted to our facility and then to the...

Thank you for your responses, everyone! Having two separate columns, one for month and day with the hidden sorting works! I really appreciate your answers. :):):):)

Sorry, I'm not really sure what you mean. For the fields, I picked "Number" type and put in the numbers. I thought you might have meant the Field Size, so I went and changed it from Long Integer to Integer, but that doesn't appear to be what you're talking about.

I tried what you suggested, putting the birth month and dates in separate columns. Then in query, I did the [BirthMonth]&"/"&[BirthDay], and then I sorted it by Ascending, but it still is ordering the birthdays by the first number, i.e. my birthdays are ordered "1, 10, 11, 12, 2, 3, 4" etc. How...

How do I get it to say "10/30" etc later on in the query and the report? I tried doing in query BirthDate: [BirthMonth]+"/"+[BirthDay], but that didn't work. I tried [BirthMonth]+"/"+[BirthDay] in the calculated field, but that didn't work either. Thanks for your response.

Hello! I'm trying to create a table with an entry for month/day, no year. I want to create a report that can will sort the birthdays based on month in ascending order. Any suggestions? I'm currently using the text field to put in, "10/30" or "1/3" but when I try to order the dates, instead of...