Search results for query: *

My laboratory uses an Access database to record specimens as they are received. We have a patient table with a unique identifier (medical record number) that ties into several specimen types (cytology, surgical path specimens, etc.) in a one-to-many relationship. The specimen tables are related...

In a a query with a series of number fields, I have a mathematical expression that detects a variance if this equation does not add up to zero. If however one of those fields is left blank, its null value results in a null value for the expression. I have tried using the following in the...

I apologize in advance for this is a repeat question from several days ago. I have a report of a multi-table query that I would like to group by table 1's indexed field, medical record number, but sort (alphabetize) by the patient's last name. When I group and sort by last then first name, the...

I have a medical report that is based on a multi-table query. The primary table's index is a patient ID number. The patient ID number in the first table (Patients)is the one-to-many link to the second table (Pathology Cases). If I sort by this number, the report captures the correct diagnoses...

I have set up a relational database with our hospital lab. There is a table of hospital patients that is linked by medical record number to 4 other tables, each representing different types of specimens. Currently we print "past-history" reports for each new specimen if it is from a...

One of the tables in my database has as a key index text field the pathology number for our lab. It is in a standard format of SYYYY-0000 with YYYY the year and 0000 consecutive integers from 0001 onward through the end of the year. I am using an input mask for entry:<br> <br>...

As a pathologist, I have a database that keeps records of cases back to 1993. The pathology accession numbers before January 1, 2000 were &quot;S followed by the two digit year number followed by a dash then the case number for that year (example S99-3579). With the new year we switched to a...

When using the Contacts folder items as the address book for MS Outlook 97, is there way to file by the last rather than the first name default other than the obvious method of changing each entry? Thanks for your help in advance.