INTRODUCTION
The Automated Vital Statistics System (AVSS)
is a health information system that is being used by many hospitals
to computerize their birth records. To make use of the valuable
demographic and medical data contained in the birth certificate,
a report generation capability is included in AVSS. The
Report Generator may be used to answer simple ad hoc queries
or to produce a variety of standard reports, including formatted
form letters, listings, crosstabulations, and summary reports.
This manual is designed to assist hospital and local health department
personnel and in learning to use the AVSS Report Generator.
It describes how to generate Standard Reports and how to use the
Query Database function. User Reports are also covered. This manual
gives step-by-step instructions, showing examples of what you
will actually see on your AVSS screen. (This assumes that
you are familiar with the basic operation of AVSS.) The
best way to use this manual is to read it in front of your computer
and try the examples presented.
If you have questions about the Standard Reports, the Query Database
function, or User Reports, please contact your local AVSS
Coordinator or:
AVSS Project-CORI
University of California
Santa Barbara, CA 93106-2150
805-893-3214
A more advanced reporting feature, the Report Editor, is also
included in the AVSS Report Generator but is not described
in this manual. If your institution has a computer expert who
wants to learn how to write custom reports using the Report Editor,
please contact the AVSS Project.
BIRTH CERTIFICATES AS A SOURCE OF DATA
The birth certificate is a deceptively small document.
Although it measures only 8 1/2" by 7 5/8", it contains
a wealth of information and serves a variety of purposes. More
than 60 pieces of information are squeezed into each certificate.
These items include demographic data which are used to identify
the child and the child's parents, as well as medical information
that describes the course and outcome of the pregnancy.
Perhaps the most frequent and most important use of the birth
certificate is for proof of identity and citizenship. Certified
copies of birth certificates are required when individuals apply
for school entry or passports, or for various governmental programs.
Another very important use of the birth certificate, however,
involves the analysis of data contained in these documents. For
example, the California Department of Finance uses birth certificate
data to estimate the future population and to plan for adequate
services (e.g., school facilities).
Birth certificate data is also used by the state and local departments
of health to monitor trends in maternal and infant health. Each
year, approximately 600,000 certificates are registered in California.
Since the content of the birth certificate is governed by State
law, which also requires that a certificate be completed for every
live birth, the data obtained from birth certificates constitutes
a very uniform and complete database.
For hospitals and local health agencies using AVSS, the
birth certificate is an excellent source of data for statistical
reports. The computer can prepare many reports that are currently
being produced manually.
WHO USES THE REPORT GENERATOR?
The AVSS Report Generator has value for several
departments in hospitals: Medical records, obstetrics, and administration.
At local health agencies it may be used for needs assessment,
program evaluation, high risk follow-up, and for well-baby programs
such as encouraging immunization.
Hospital Medical Records
Medical records is one of the primary beneficiaries
of the AVSS Report Generator. Since medical records is
often the department that owns and operates AVSS, it is
natural for this department to learn to use the AVSS Report
Generator. The Standard Reports and Query Database function may
be used to answer general questions that have been directed to
the Medical Records Department (e.g., how many deliveries, C-sections,
etc. occurred during a given time period [#HSR1T]. However, the
AVSS Standard Reports may also be used to maintain permanent
records; e.g., keeping a permanent copy of the Newborn Listing
Report [#HNB1L] and/or Non-confidential Newborn Listing Report
[#HNB2L] instead of a handwritten birth certificate log.
Many of the AVSS reports also assist the Medical Records
Department in monitoring the accuracy of birth certificate data
entry. For example, the Newborn Listing report [#HNB1L] may be
used as a cross-check against the handwritten OB labor log in
order to make sure that all live births have been entered into
the computer (and that all babies with AVSS birth certificates
are shown in the OB labor log). The Newborn Listing report also
can reveal errors that might have been made in entering the babies'
medical record numbers into AVSS, as well as certain information
that might be missing from the birth certificate; e.g., birth
weight, method of delivery, MD name.
Department of Obstetrics
The AVSS Standard Reports were developed in
cooperation with the Perinatal Advisory Council for Los Angeles
Communities (PAC/LAC). PAC/LAC encourages member hospitals to
collect statistics on a monthly basis. Virtually all maternity
hospitals in Los Angeles County belong to PAC/LAC and are striving
to collect these recommended statistics. Since most of this data
is included in the birth certificate, AVSS can greatly
simplify the process of gathering statistics. Some of the AVSS
reports that may be used for PAC/LAC or hospital Quality Assurance
purposes include the following: MD Name By Primary/Repeat Csection
Rates [#HMDCS2X]; Low Birthweight Listing [#HLOBW1L]; Labor and
Delivery Complications/Procedures [#HLDCT], and Summary Report
[#HSR1T].
Hospital Administration
Hospital administrators can also benefit from AVSS.
Several AVSS reports may be used to study OB service utilization.
For example, administrators can monitor the characteristics of
OB patients; e.g., maternal age, race, educational level, parity,
zip code of residence [#HSR1T], and use this information to develop
appropriate marketing strategies. Reports addressing such physician
practices as method of delivery [#HMDCS2X], delivery by birth
weight categories [#HMDBW2X], and monthly delivery statistics
[#HMD2AX and #HMD2BX] might be used for credentialing purposes.
Local Health Departments
Local health departments can use AVSS to generate many
tabulations and cross tabulations that traditionally have required
statistical software. Although these are elementary tables usually
reporting only row percentages (RP), they can be useful for answering
such questions as what percentage of teen mothers had their prenatal
care paid for by Medi-Cal versus HMOs versus no insurance [#CPAY1X]?
Or what is the age distribution for Blacks versus White-Non-Spanish
versus White-Spanish [#CAGE1X and #CAGE2X]? AVSS reports can also
be used for quality control, both at the hospital and at the health
department. For example, [#CLATR1T] reports the percentage of
births registered within the 10 day limit specified by California's
Health and Safety Code. The classification of race is a particularly
difficult problem in our diverse culture and the AVSS reports
[#CHISP1T] and [#CRACET] allows us to examine unusual combinations,
some of which may indicate the need for user training.
REPORT GENERATOR OPTIONS
The AVSS Report Generator has four suboptions,
which will be described further below, including
Query Database
Report Editor
Generate Report
Output Saved Report
Query Database
Query Database is a relatively easy-to-use, interactive
tool for ad hoc queries. It may be used to search the database,
using one or more variables (fields) from the birth certificate.
Query Database produces one dimensional tabulations, after locating
birth records that satisfy the conditions specified in the query.
The resulting report will indicate the records that met the final
selection criteria. Query Database performs relatively rapid searches,
depending on the size of the database and the number of conditions
specified, and it is flexible in its method of identifying a special
subset of births. The main disadvantage of Query Database is the
output reporting format, which is very limited.
Report Editor
The Report Editor is a general purpose tool that allows
the creation of customized reports. Reports may be written in
a variety of formats, including: form letters, listings, cross
tabulations, and summary reports. Due to the complexity of this
option, however, a set of Standard Reports has been included in
AVSS which will meet most of the hospital's reporting needs.
Generate Report
Use the Generate Report suboption to run any of the
AVSS Standard Reports (or to run custom reports that have
been developed using the Report Editor). The Standard reports
may be run in the foreground and sent directly to the terminal,
printer, or PS-DOS file. Alternatively, the reports may be run
in the background and retrieved at a later time.
Output Saved Report
Reports that have been run in the background may be
retrieved by using the Output Saved Report suboption. Report output
may be sent to the terminal, printer, or PCDOS file and
will be saved under Output Saved Report until they are deleted.
This means that the reports may be viewed or printed many times.
However, the saved reports can clutter your AVSS output
report area and consume valuable disk space, if they are left
there indefinitely.
HOW TO GENERATE STANDARD REPORTS
All AVSS standard reports begin with a # character
(or the % character for 1988 or earlier birth certificates).
The second character specifies whether AVSS will search over Hospital
Birth Records (#H reports), or Birth Certificates (#C,
#F, or #R reports). Only hospitals operating AVSS
on their own stand-alone computer will run the #H reports.
All AVSS reports scan over AVSS "forms", which have
3 letter names. The #H reports search over the HCA
(Hospital CAlifornia) forms, corresponding to Hospital
Birth Records, by hospital of birth occurrence. The #C
reports search over the LCA (Local CAlifornia)
forms, corresponding to Birth Certificates, by County of
birth occurrence. For example, all births occurring in Alameda
County. The #F reports scan over LCA forms by Facility
range of birth; for example, all births occurring in non profit
hospitals in Alameda County, or simply all the births occurring
at Highland General Hospital. The #R reports scan over
LCA forms by county of mother's Residence. For example,
births to women residing in Alameda County regardless of the county
in which the birth occurred. The examples given in this manual
are all #C reports; to run other reports just substitute
#F, #H, or #R as necessary.
Follow the steps below to generate one or more of the AVSS
Standard Reports. The responses you must type are highlighted
in bold. Don't forget to press [ENTER] after typing the
required keystroke.
In the Foreground
The instructions below show you how to run a Standard
Report in the foreground. "Foreground" means that the
report will occupy your computer while it is running. You won't
be able to do anything else with your computer until the report
finishes. This should not be a major problem, however, since most
reports will take only a few minutes to run. (The actual length
of time will depend on the speed of your computer, the number
of births at your facility, the time period covered by the report,
and how many other AVSS functions are being performed at
the same time.)
PASSWORD >
WELCOME TO AVSS 4.2
Automated Vital Statistics System
AVSS PROJECT COMPUTER
Copyright 1987 The Regents of the University of California
GOOD EVENING RON
TODAY IS THURSDAY 3/11/93 AT 06:05 PM
LAST LOGIN ON THURSDAY 3/11/93 AT 12:50 PM
SYSTEM OPTION > [R][ENTER]EPORT GENERATOR
REPORT GENERATOR OPTION> [G][ENTER]ENERATE REPORT
REP. REPORT > [#C][ENTER]
(Or type #F, #R, or #H to select
different types of reports as discussed above.)
1 #CAGE1X=TEENAGE CROSS TABS BY OCCURRENCE
2 #CAGE2X=MATERNAL AGE CROSS TABS BY OCCURRENCE
3 #CANOMT=CONGENITAL ANOMALIES BY OCCURRENCE
4 #CBW1X=BIRTH WEIGHT CROSS TABS BY OCCURRENCE
5 #CDLVY1X=METHOD OF DELIVERY CROSS TABS BY OCCURRENCE
6 #CED1X=MATERNAL EDUCATION CROSS TABS BY OCCURRENCE
7 #CETH1X=ETHNICITY CROSS TABS BY OCCURRENCE
8 #CGABWX=GESTATIONAL AGE BY BIRTH WEIGHT BY OCCURRENCE
9 #CHISPT=HISPANIC SPECIFICATIONS BY OCCURRENCE
10 #CLATR1T=LATE REGISTRATION
11 #CLDCT=LABOR AND DELIVERY COMPLICATIONS/PROCEDURES BY OCCURRENCE
12 #CLDCT89=LABOR AND DELIVERY COMPLICATIONS/PROCEDURES BY OCCURRENCE
13 #CLOBW1L=LOW BIRTH WEIGHT LISTING BY OCCURRENCE
14 #CMDBW1X=MD LICENSE # BY BIRTH WEIGHT BY OCCURRENCE
15 #CMDBW2X=MD NAME BY BIRTH WEIGHT BY LRD OF OCCURRENCE
16 #CMDCS1X=MD LICENSE # BY PRI/RPT CSECTION RATES BY OCCURRENCE
17 #CMDCS2X=MD NAME BY PRI/RPT CSECTION RATES BY OCCURRENCE
18 #CMDM1AX=MD LICENSE # BY MONTH (1ST SIX MONTHS) BY OCCURRENCE
19 #CMDM1BX=MD LICENSE # BY MONTH (2ND SIX MONTHS) BY OCCURRENCE
20 #CMDM2AX=MD NAME BY MONTH (1ST SIX MONTHS) BY OCCURRENCE
HIT RETURN TO CONTINUE, Q OR ^Q TO QUIT, OR SELECTION # > [Q][ENTER]
SELECTION # >[ENTER]
REP. REPORT > #CSR1T = SUMMARY REPORT BY OCCURRENCE
CNTY. COUNTY <34> [ENTER] = SACRAMENTO
ENTER BEGINNING VALUE FOR DATE OF BIRTH < 1/1/93 > [ENTER]
(1/1/93)
ENTER ENDING VALUE FOR DATE OF BIRTH < T > [ENTER]
(3/11/93)
RUN THIS REPORT IN THE BACKGROUND <N>[ENTER]
SAVE THE OUTPUT FROM THIS REPORT <N>[ENTER]
OUTPUT DEVICE <T>[ENTER]
PREPARING REPORT.............................................................
EXECUTING REPORT...
SUMMARY TABULATIONS FOR FORM: LCA
BY OCCURRENCE AT: AVSS PROJECT COMPUTER REPORT CODE: #CSR1T
DATE RANGE: 1/1/93 TO 3/11/93 TODAY: 3/11/93
MOTHER'S AGE
MOM-AGE | COUNT
---------------------
<20 | 236
(CP) 12.8%
20-24 | 442
(CP) 24.0%
25-29 | 546
(CP) 29.6%
30-34 | 402
(CP) 21.8%
35-39 | 182
(CP) 9.9%
40+ | 36
(CP) 2.0%
---------------------
TOTAL | 1844
In the Background
These instructions show you how to run a Standard Report
in the background. "Background" means that you can use
AVSS for other functions, while the report is running.
SYSTEM OPTION > [R][ENTER]EPORT GENERATOR
REPORT GENERATOR OPTION > [G][ENTER]ENERATE REPORT
REP. REPORT > [#CA][ENTER]
1 #CAGE1X=TEENAGE CROSS TABS BY OCCURRENCE
2 #CAGE2X=MATERNAL AGE CROSS TABS BY OCCURRENCE
3 #CANOMT=CONGENITAL ANOMALIES BY OCCURRENCE
SELECTION # > [2][ENTER] #CAGE2X = MATERNAL AGE CROSS
TABS BY OCCURRENCE
CNTY. COUNTY <34> [ENTER] = SACRAMENTO
ENTER BEGINNING VALUE FOR DATE OF BIRTH < 1/1/93 > [ENTER]
(1/1/93)
ENTER ENDING VALUE FOR DATE OF BIRTH < T > [ENTER]
(3/11/93)
RUN THIS REPORT IN THE BACKGROUND <N> [Y][ENTER]
SOC. SAVE OUTPUT CODE > [CAGE2X][ENTER]
ENTER A DESCRIPTION FOR THIS REPORT > [AGE XTABS FOR
1ST TWO MONTHS OF 1993][ENTER]
DELAY UNTIL <NOW>[ENTER]
THIS REPORT BEING RUN IN THE BACKGROUND
EXIT
Note: The screen will blank out almost immediately after pressing
[ENTER] at the DELAY UNTIL <NOW> prompt.
HOW TO RETRIEVE REPORTS RUN IN THE
BACKGROUND
Follow the steps below to retrieve the reports you
have run in the background. The responses you must type are highlighted
in [BOLD]. Don't forget to press [ENTER]
after typing the required keystrokes.
SYSTEM OPTION > [R][ENTER]EPORT GENERATOR
REPORT GENERATOR OPTION > [O][ENTER]UTPUT SAVED REPORT
OUT. OUTPUT REPORT CODE > [C][ENTER]
1 CAG13392=CAGE1X IN C33 FOR 1992 (2/19/93 02:42 PM)
2 CAG19233=AGE REPORT IN C33 FOR 1992 (2/19/93 01:34 PM)
3 CAGE2X=AGE XTABS FOR 1ST TWO MONTHS OF 1993 (3/11/93 06:17 PM)
4 CANM3392=CANOMT (ANOMS) IN C33 FOR 1992 (2/19/93 03:06 PM)
5 CBW3392=BW XTABS IN C33 FOR 1992 (2/19/93 04:35 PM)
6 CDLV3392=MOD IN C33 FOR 1992 (2/19/93 03:44 PM)
7 CED3392=ETH XTABS IN C33 FOR 1992 (2/19/93 06:15 PM)
8 CETH9233=ETH XTABS IN C33 FOR 1992 (2/22/93 11:06 AM)
9 CGBW3392=GA BY BW IN C33 FOR 1992 (2/22/93 11:38 AM)
10 CHSP3392=HISP SPECIFICATIONS IN C33 FOR 1992 (2/22/93 11:58
AM)
11 CLAT3392=LATE REG IN C33 FOR 1992 (2/22/93 12:13 PM)
12 CLDC3392=L/D COMPS IN C33 FOR 1992 (2/22/93 12:25 PM)
13 CLOB3392=LO BW LISTING IN C33 FOR 1992 (2/22/93 12:46 PM)
14 CMDBA332=MD NAME BY BW IN C33 FOR 1992 (2/22/93 01:15 PM)
15 CMDBW332=MD LIC # BY BW IN C33 FOR 1992 (2/22/93 01:01 PM)
16 CMDC1332=MD LIC # BY PRI/RPT CSEC RATES (2/22/93 01:31 PM)
17 CMDC2332=MD NAME BY PRI/RPT CSEC RATES (2/22/93 01:46 PM)
18 CMDM1A32=MD LIC # BY 1ST SIX MONTHS (2/22/93 01:47 PM)
19 CMDM1B32=MD LIC # BY 2ND SIX MONTHS IN C33 FOR 92 (2/22/93
01:50 PM
20 CMDM2A32=MD NAME BY 1ST SIX MONTHS C33 FOR 92 (2/22/93 02:59
PM)
HIT RETURN TO CONTINUE, Q OR ^Q TO QUIT, OR SELECTION #
> [3][ENTER] CAGE2X = AGE XTABS FOR 1ST TWO MONTHS OF
1993 (3/11/93 06:17 PM)
CAGE2X =AGE XTABS FOR 1ST TWO MONTHS OF 1993 (3/11/93 06:17 PM)
CAGE2X =[ENTER]
OUTPUT DEVICE <T> [^L][ENTER]
T =TERMINAL
P =PRINTER SLAVED TO TERMINAL
F =PC-DOS FILE
OUTPUT DEVICE <T> [F][ENTER]
ENTER OUTPUT FILE NAME > [CAGE2X.REP][ENTER]
DO YOU WANT TO FREE THIS TERMINAL <N>[ENTER]
PRINTING...
Note: AVSS will write the report to a PC-DOS file that can
then be used by other software packages such as wordprocessors.
Alternatively, the output can be routed to the screen by simply
accepting the <T> default:
OUTPUT DEVICE <T> [ENTER]
CROSS TABS BY MOTHER'S
AGE FOR FORM: LCA
BY OCCURRENCE AT: AVSS PROJECT COMPUTER REPORT CODE: #CAGE2X
DATE RANGE: 1/1/93 TO 3/11/93 TODAY: 3/11/93
MOTHER'S ETHNICITY BY MOTHER'S AGE
MOM-AGE
ETHNCTY | <20 | 20-24 | 25-29 | 30-34 | 35-39 | 40+ | TOTAL
----------------------------------------------------------------------
ASIAN | 18 | 40 | 41 | 40 | 22 | 10 | 171
(RP) 10.5% 23.4% 24.0% 23.4% 12.9% 5.8% 100.0%
BLACK | 61 | 63 | 64 | 39 | 14 | 4 | 245
(RP) 24.9% 25.7% 26.1% 15.9% 5.7% 1.6% 100.0%
OTHER | 6 | 23 | 22 | 31 | 7 | 2 | 91
(RP) 6.6% 25.3% 24.2% 34.1% 7.7% 2.2% 100.0%
W-NSPN | 101 | 225 | 350 | 238 | 112 | 17 | 1043
(RP) 9.7% 21.6% 33.6% 22.8% 10.7% 1.6% 100.0%
W-SPAN | 50 | 91 | 69 | 54 | 27 | 3 | 294
(RP) 17.0% 31.0% 23.5% 18.4% 9.2% 1.0% 100.0%
----------------------------------------------------------------------
TOTAL | 236 | 442 | 546 | 402 | 182 | 36 | 1844
HIT RETURN TO CONTINUE, 'Q' OR '^Q' TO QUIT >[Q][ENTER]
HOW TO DELETE REPORTS RUN IN THE BACKGROUND
The steps below show how to delete reports that you
have run in the background. This should be done periodically,
when you no longer need the reports, so that valuable disk space
in AVSS is not wasted. Don't forget to press ENTER after
typing the required keystrokes.
SYSTEM OPTION > [R][ENTER]EPORT GENERATOR
REPORT GENERATOR OPTION > [O][ENTER]UTPUT SAVED REPORT
OUT. OUTPUT REPORT CODE > [CAGE2X][ENTER] = AGE XTABS
FOR 1ST TWO MONTHS OF 1993 (3/11
06:17 PM)
CAGE2X =AGE XTABS FOR 1ST TWO MONTHS OF 1993 (3/11/93 06:17 PM)
CAGE2X =[?][ENTER]
K=KILL B=BLANK D=DELETE I=INSERT R=REPLACE Q=QUIT (START OVER)
SPACE TO THE DESIRED POSITION AND ENTER THE EDIT CODE.
ENTER THE TITLE FOR THIS REPORT.
CAGE2X =AGE XTABS FOR 1ST TWO MONTHS OF 1993 (3/11/93 06:17 PM)
CAGE2X =[K][ENTER] OK TO DELETE? [Y][ENTER]
OUT. OUTPUT REPORT CODE >[ENTER]
REPORT GENERATOR OPTION >[ENTER]
HOW TO QUERY THE DATABASE
The Query Database suboption may be used to answer
questions you have been asked (e.g., "How many deliveries
did Dr. Smith, license number G1234, perform during September?")
or to locate specific records that have shown up in one of the
Standard Reports (e.g., "Who were the four births to teenage
mothers with no prenatal care during October?")
Follow the steps to learn how to query your database with this
simple example:
SYSTEM OPTION > [R][ENTER]EPORT GENERATOR
REPORT GENERATOR OPTION > [Q][ENTER]UERY DATABASE
INITIALIZING .....
FORM SELECTION > [LCA] [ENTER] = BIRTH CERTIFICATE
XIND. SITE CODES > [34][ENTER]
XIND. SITE CODES >[ENTER]
THE FOLLOWING SITES / FORMS WILL BE REPORTED ON:
34 LCA
LEVEL 1: FIELD TO BE REPORTED ON > [2][ENTER] (SEX OF
CHILD)
LEVEL 1: PLEASE ENTER SPECIFIC VALUE(S) > [FEMALE][ENTER]
LEVEL 2: FIELD TO BE REPORTED ON > [1A][ENTER] (FIRST
(GIVEN) NAME OF CHILD)
LEVEL 2: PLEASE ENTER SPECIFIC VALUE(S) >[ENTER]
INDEX TO SEARCH <DATE OF BIRTH>[ENTER]
ENTER BEGINNING VALUE FOR DATE OF BIRTH < 1/1/93 > [ENTER]
(1/1/93)
ENTER ENDING VALUE FOR DATE OF BIRTH < T > [1 2][ENTER]
(1/2/93)
DO YOU WANT FILE VARIABLE VALUES ON ALL RECORDS FOUND DURING THE
QUERY <N>[ENTER]
SAVE THESE COMMANDS FOR THE REPORT GENERATOR <N>[ENTER]
RUN THIS REPORT IN THE BACKGROUND <N>[ENTER]
SAVE THE OUTPUT FROM THIS REPORT <N>[ENTER]
SAVE THE OUTPUT FROM THIS REPORT <N>[ENTER]
OUTPUT DEVICE <T>[ENTER]
SEARCHING DATABASE XXXXXXXX
88 CERTIFICATES ARE REGISTERED
38 CERTIFICATES OF THOSE HAD OTHER THAN THE SPECIFIED VALUE(S)
LEAVING 50
THE NUMBER OF CERTIFICATES REPORTED ON IS 50 (56.82%)
DO YOU WISH TO GROUP, SEE DISTINCT VALUES, CONTINUE, OR QUIT (G/V/C/Q)
>[V][ENTER]
ADENA ... 1 ... 2.00% FILE# 19334000110 (34:LCA)
ALYSSA ... 1 ... 2.00% FILE# 19334000164 (34:LCA)
AMANDA ... 1 ... 2.00% FILE# 19334000055 (34:LCA)
ANGELICA ... 1 ... 2.00% FILE# 19334000001 (34:LCA)
BROOKE ... 2 ... 4.00%
CHRYSTINA ... 1 ... 2.00% FILE# 19334000115 (34:LCA)
CRYSTAL ... 1 ... 2.00% FILE# 19334000076 (34:LCA)
DAKOTA ... 1 ... 2.00% FILE# 19334000112 (34:LCA)
DANIELLE ... 2 ... 4.00%
DEJA' ... 1 ... 2.00% FILE# 19334000018 (34:LCA)
DELINNA ... 1 ... 2.00% FILE# 19334000090 (34:LCA)
DESIREE ... 1 ... 2.00% FILE# 19334000139 (34:LCA)
ELAINE ... 2 ... 4.00%
ELYSE ... 1 ... 2.00% FILE# 19334000183 (34:LCA)
EVELINE ... 1 ... 2.00% FILE# 19334000034 (34:LCA)
GABRIELLA ... 1 ... 2.00% FILE# 19334000067 (34:LCA)
HEATHER ... 1 ... 2.00% FILE# 19334000375 (34:LCA)
JASMINE ... 2 ... 4.00%
JENNIFER ... 1 ... 2.00% FILE# 19334000376 (34:LCA)
JESSE ... 1 ... 2.00% FILE# 19334000793 (34:LCA)
JESSICA ... 1 ... 2.00% FILE# 19334000128 (34:LCA)
HIT RETURN TO CONTINUE, 'Q' OR '^Q' TO QUIT >[Q][ENTER]
In the above example, the database consisted of 88
births during the first 2 days of 1993, 50 of which were female.
Although Query Database can perform searches using multiple selection
criteria (we only used one above), it can only report on records
that meet the final variable specified. Note: If you answer "YES"
to the question: "DO YOU WANT FILE VARIABLE
VALUES ON ALL RECORDS FOUND DURING THE QUERY", Query
Database will give you the file number of all of the babies that
meet the selection criteria, not just the ones for which there
was only one unique value.
Updated September 22, 1996 by RL Williams
