Abrown at 11:04, 30 May 2012

2012-05-30T11:04:47Z

← Older revision		Revision as of 12:04, 30 May 2012
Line 87:		Line 87:


	[[Using ~~the~~ Report Generator\|Back]]		[[Using Report Generator\|Back]]

Abrown: Created page with "All of Optisoft’s data is stored in tables relating to a specific element, the Patients table, for example, contains the patient data. These tables are broken down into fields,..."

2012-05-30T11:04:07Z

Created page with "All of Optisoft’s data is stored in tables relating to a specific element, the Patients table, for example, contains the patient data. These tables are broken down into fields,..."

New page

All of Optisoft’s data is stored in tables relating to a specific element, the Patients table, for example, contains the patient data. These tables are broken down into fields, for example the FirstNames, Surname and Date of Birth fields.

== Example 1 ==

In this example we will create a set of criteria that will find all of the patients with the surname of Smith.

*Select the Patients table in the table box

<<IMAGE HERE>>

*Select the Surname field in the fields box

<<IMAGE HERE>>

*This will open the Enter Search Value dialogue

<<IMAGE HERE>>

*Enter Smith into the Search For box

*Click OK to add the criteria to the search list on the right side of the screen.

<<IMAGE HERE>>

== Example 2 ==

In this example we will create a set of criteria that will locate all of the patients on the database who are over 60 and have a prescription of +4 sphere or higher.

*Select the Patients table in the table box

*Select the Date of Birth field in the fields box

*Double click on the < (less than) in the criteria box

*This will open the Enter Search Value dialogue

<<IMAGE HERE>>

*Enter 01/01/1947 in the search box. This will provide the results for all patients whose date of birth was before 01/01/1947.

*Click OK to add the criteria to the search list.

*Now select the Patients Rxs table in the table box

<<IMAGE HERE>>

*Select the R Sphere field in the Fields list

*Double click on the >= (greater than or equals to) in the criteria box

<<IMAGE HERE>

*Enter 4 into the Enter Search Value dialogue and click OK.

These criteria will provide us with a list of all patients over 60 with a right sphere measurement of +4 or higher, but patients have two eyes so the criteria are not complete. We will need to use the OR statement to combine 2 separate queries.

<<IMAGE HERE>>

*Click on the OR radio button

*Select the Patients table in the table box again

*Select the Date of Birth field in the fields box

*Double click on the < (less than) in the criteria box

*Enter 01/01/1947 in the Enter Search Value dialogue and click OK.

*Click on the AND radio button to change the Combine Using method again.

*Select the Patients Rxs table in the table box

*Select the L Sphere field in the Fields list

*Double click on the >= (greater than or equals to) in the criteria box

*Enter 4 into the Enter Search Value dialogue and click OK.

<<IMAGE HERE>>

*We now have a set of criteria that will find patients over 60 with a right sphere of +4 or higher OR patients over 60 with a left sphere of +4 or higher.

It is important to note that the OR method effectively draws a line under the previous set of criteria and starts a fresh query whose results are then added to those of the previous part.

[[Using the Report Generator|Back]]

Search Tab - Revision history

Abrown at 11:04, 30 May 2012

Abrown: Created page with "All of Optisoft’s data is stored in tables relating to a specific element, the Patients table, for example, contains the patient data. These tables are broken down into fields,..."