Query example ii – Honeywell HRSD4 User Manual

Page 122

Advertising
background image

Text-In Query Examples

122

Query Example II

1

2

3

4

5

6

123456789012345678901234567890123456789012345678901234567890

Item

Unit price

Qty

amount

==============================================

Coke

| $ 2.20 |

1(s) |

$

2.20

Fanta

| $ 2.20 |

1(s) |

$ 2.20

Hotdog

| $ 3.50 |

3(s) |

$ 10.50

Pepsi

| $ 1.95 |

1(s) |

$

1.95

==============================================

total : $ 16.85

Thank you~~

In the above text-in data, you can find that the comparison value is located at 17th (Unit
price, $ mark will be ignored automatically), 28th (Qty) and 40th (amount) characters
(including spaces) from the left, but the value of amount category is located on a
different line from Item. In this case, you can enter 17, 28, and 40 in each Column field
and enter 1 in the Line field for the next line.

For example, if you want to search for Coke with a Qty (Quantity) of more than 1 and
Hotdog with an amount totaling over $8, the following search condition can be set.

Figure B-2

Text-In Query Example 2

Advertising