John Toliver wrote:
Hello all,
I need some help. I'm new to creating databases. I have only
recently developed interest in them when I discovered how I can
structure my information into database format and use it to
computerize and simplify my paperwork flow. A little background, I'm
a nursing student. If you're familiar at all with the field, you're
aware that a fair amount of it has to do with paperwork. At the
least, creating a table like document with select points of interest
for medicine, lab values, diagnostic results pathophysiology etc. for
each patient under my care. I have figured out how to take the data I
gather, and convert it in to tables with the proper formatting to
display the data the way that I need to for submission.
With that said I have a few questions about methods of manipulating data:
1. When I create a report, I may spend an hour or more getting the
report so that it formats my data the way I want it to display. I
choose to have my report set to display the results of a query. If I
wish to create another report looking at different aspects of the data
I would do this through another query (ie scenario 1: query me all
apples in report format A. scenario 2: query me all oranges in report
format A)
The least complicated approach is to use parameterized query as the
bases for your report.
In fact you can go back, assuming you have already created both your
report, and your query and that parameter to the existing query to gain
the functionality.
Suppose your query looks like:
SELECT * FROM "tbl_patients_as_fruit"
You based your report on this - now open the query in design mode and
add a new column ( I assume there is a column named Fruit_variety )
After adding the column Fruit_varitety to the query move to the cell in
the new column named "Criteria" and enter this
:VARIETY
The colon tells the query engine that this is a parameter that should be
replaced with a value when it is run.
OK - now when you run report A, a dialog box will pop up and ask you for
the value to use for VARIEY
You enter Apples and you get a report for just Apples.
If you run the report again, it again asks and you enter Oranges - your
report is only for Oranges.
You can have more then one named parameter in your query also - so for
instance you could add another column for "Date_Picked" and a parameter
:PICKED
The dialog box will now ask for the values of VARIETY and PICKED you answer
Apples
02/13/08
Now your report is only going to display records for yesterday's harvest :>)
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
