Search results for query: *

Dear alvechurchdata, Your help was just what I needed. I have to work around my lack of SQL knowledge but what I have now are two queries, one to select the medical record number of surgical path reports for the last six months and then a second to find the matching medical record number of...

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

Thanks very much for your quick response. My main problem was my lack of knowledge on how and where to plug in one of these functions. It was not working to plug it into the criteria lines of the number fields, but it works when I use the Nx function for each of the four values in the...

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

Thank you very much. I had to go back and learn more about expression building and tinker with where the expression should be placed but it now works very well. I built the expression into the query, created an invisible field in the report (because I already had the report spacings like I...

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 would like to keep the specificity of the indexed patient ID number in case I have two patients with the same first and last name, which happens quite often. Is it possible to "group" by the index patient ID number but "sort " alphabetically by last, then first name?

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

Multiple queries and reports with one master report? How does one embed a report into another report?<br><br>JeffreyE

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 &quot;past-history&quot; 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>...

INSERT INTO [Diagnoses--Autopsies] ( autAutopsyNo )<br> SELECT [Diagnoses--Autopsies Query].autAutopsyNo<br> FROM [Diagnoses--Autopsies Query]<br> WHERE ((([Diagnoses--Autopsies Query].autAutopsyNo)=Left$([autAutopsyNo],1) & &quot;19&quot; & Mid$([autAutopsyNo],2,10)));<br> <br> This is the SQL...

I have been successful through the select query that did not include the Y2K group and I have changed the query to append. Then I must be doing something wrong. I keep receiving &quot;You are about to append 0 records.&quot; I think it is something wrong with where or how the SQL statement is...

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.