Apple M9057 User Manual - Page 210

8-28 AppleWorks 5 User's Manual In Browse or List mode, To match records choose Match Records from that contain the Organize menu, and then Example formula A specific value in a pop-up menu or radio button field Click the NUMTOTEXT(number) function and replace number by selecting it and clicking the field name. Click the = operator, and then type the value in double quotation marks. Selects the Italian restaurants A selected or deselected checkbox field Click the field name and click the = operator. Then type true to find selected fields, or false to find deselected fields. Selects the reviewed restaurants A value that's more than one value and less than another value Click the AND (logical1, logical2,...) function, and then replace logical1, logical2,... with the values you want, separating each with a comma. Finds the restaurants with meal prices more than $5 but less than $15 A date that is later than the specified date Click the field name, click the > operator, and then use the TEXTTODATE function to specify the date. Finds the restaurants visited in 1997 Working with layouts When you work with a database in Browse mode, you see the fields arranged in a layout, an arrangement of fields, field labels, and other objects that determine the way data looks when it's displayed and printed. AppleWorks automatically creates the standard layout you see in Browse mode when you create a database. You can change the layout and create additional layouts for the same data, each one for a different purpose. Understanding layouts In the Help index,* see: E Layout mode You create and work with layouts in Layout mode. You can use all the drawing tools and commands available in AppleWorks to design your layouts. You don't enter or edit data in Layout mode, so creating or changing a layout has no effect on the data in the database. * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.