Possibility to filter the records in a Database

[Elbanco]

Hi,
How to study the possibility to filter the records in order to recover only those that meet predefined conditions in a database. I am looking for the appropriate solution for the same. I need some suggestion for exploring the possibilities to filter the records in order to recover only those that meet predefined conditions. Also what are the possibilities to combines records with identical values in the list of fields specified in a single record. Thanks of any suggestions.

[kelfro]

Before the implementation of this paragraph must emphasize three vital details. The first is that every time you want to set a condition referred to a text field, the search condition must be enclosed in single quotes, the second is that it is possible to set search conditions and in memo fields, the third and last reference to the dates. To the date I have not been able to find a syntax that works on all systems, so it is necessary to particularize the database as:
Data Bank - Syntax
SQL-SERVER - Date = # mm-dd-yyyy #
ORACLE - Date = to_date ( 'YYYYDDMM', 'yyyymmdd',)
ACCESS - Date = # mm-dd-yyyy #

[Zecho]

Logical operators are supported by SQL: AND, OR, XOR, Eqv, Imp, and Is Not. Except for the last two all possess the following syntax: <expresión1> operator <expresión2>. Where expression1 and expression2 are the conditions to assess the outcome of the operation varies according to the logical operator. To indicate that we want to retrieve the records according to the range of values in a field we use the Between operator whose syntax is: field [Not] Between value1 And value2 (Not condition is optional). In this case the query would return records containing the "field" value included in the interval value1, value2 (inclusive). Not provided by preceding return those values outside the range.

[Zecho]

Logical operators are supported by SQL: AND, OR, XOR, Eqv, Imp, and Is Not. Except for the last two all possess the following syntax: <expression1> operator <expression3>. Where expression1 and expression2 are the conditions to assess the outcome of the operation varies according to the logical operator. To indicate that we want to retrieve the records according to the range of values in a field we use the Between operator whose syntax is: field [Not] Between value1 And value2 (Not condition is optional). In this case the query would return records containing the "field" value included in the interval value1, value2 (inclusive). Not provided by preceding return those values outside the range.