Searching for specific records within a database

  • Thread starter Thread starter Steve Harris
  • Start date Start date
S

Steve Harris

I work in a hospital laboratory, one of the instruments we
use stores patient data and blood test results in Access
files. I want to be able to search these files for
individual records. What would be the best way to do
this. Ideally, I would like to set up an empty database
and then import the relevent daily data file.
The databases contain two tables, one contains patient
details with a unique identifier and the other contains
the results of the tests performed.
Thanks in advance.
Steve Harris.
 
Steve,

The simplest way would be to use the unique identifier in the patients table
as the relationship with the results table.

You can then have a select query to pull all the data together, joining the
two table with the identifier. Then set the criteria for the identifier to
[ID]

Each time you open the query you will be prompted for the ID and all the
results relating to that patient will be displayed.

Not sure if theis is exactly what your after but short of designing forms do
diplay the data this is quick and easy.

Marcus Armand
 
Back
Top