@Normal@<:#240,4200><:f900,6Times New Roman,0,0,0><+!><:f900,BHelveticaNeue MediumCond,0,0,0><-!><:f><+!><:f200,2Tms Rmn,0,0,0>
<:#336,4200><+!><:f280,2Tms Rmn,0,0,0><-!><+!><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> Tip 1<:f200,2Tms Rmn,0,0,0>
@Normal@<:#240,4200><+!><:f200,2Tms Rmn,0,0,0>Quick Date Entry<-!><:f200,FArial,0,0,0>
@Normal@<:#1440,4200><:f200,6Times New Roman,0,0,0>Speed up data entry by using Approach</R>s quick method of entering a date for the current month and year. Just type the number representing the day of the month and Approach uses the computer's system date to automatically en
ter the current month and year.
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#720,4200><:f200,6Times New Roman,0,0,0>Example: Typing a 10 in a date field returns 2/10/93 when the current month is February and the current year is 1993.
@Normal@<:#96,4200><:f80,FArial,0,0,0>
@Normal@<:#336,4200><+!><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> Tip 2<:f200,2Tms Rmn,0,0,0>
@Normal@<:#240,4200><+!><:f200,2Tms Rmn,0,0,0>Adding a Body Panel to a Summary Report<-!><:f200,FArial,0,0,0>
@Normal@<:#480,4200><:f200,6Times New Roman,0,0,0>You can add a body to an existing summary report without recreating the entire report:
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@step@<:#240,4200>1. Switch to design mode for the summary report.
@step@<:#240,4200>2. From the Design Menu, choose Add Summary.
@step@<:#720,4200>3. It doesn</R>t matter what this summary summarizes over,but make it a Left summary rather than a Center Summary and click OK.
@step@<:#720,4200>4. Approach will add a Left summary and also a body panel to fill the space from the end of the Left summary to the margin.
@step@<:#720,4200>5. Now select the Left summary with the right mouse button so that it is highlighted (outlined in blue).
@step@<:#240,4200>6. Press the delete key to delete the Left summary.
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>7. What remains is a body panel.
@Normal@<:#336,4200><+!><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> Tip 3<:f200,2Tms Rmn,0,0,0>
@Normal@<:#240,4200><+!><:f200,2Tms Rmn,0,0,0>Separate Last Names and First Names<-!><:f200,FArial,0,0,0>
@Normal@<:#1200,4200><:f200,6Times New Roman,0,0,0>The following formulas extract the first and last names from a field containing a full name and places them in the calculated fields First and Last. This allows you to sort on either the first name or last name.
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#960,4200><:f200,6Times New Roman,0,0,0>Example 1: Separate the contents of a FullName field into two fields, one for the first name and one for the last name. The FullName field holds information in the form: Adams, John.
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>Last: Left(FullName,(Position(FullName,',',1)-1))
@Normal@<:#480,4200><:f200,6Times New Roman,0,0,0>First: Right(FullName, (Length(FullName)-(Position(FullName,',',1)+1)))
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#720,4200><:f200,6Times New Roman,0,0,0>Example 2: Same as above except the FullName field may contain the information in the form of John Adams or John K. Adams.
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>First: Left(FullName,Position(FullName,' ',1))
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#960,4200><:f200,6Times New Roman,0,0,0>Note that the formula entry ' ' is a single quote, a space, and another single quote. You must press the space bar to enter the space between the two single quotes.
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#720,4200><:f200,6Times New Roman,0,0,0>Last: If(Position(FullName,' ', Position(FullName,' ',1)+1)=0, Right(FullName, (Length(FullName)-(Position(FullName,' ',1)))),
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>Right(FullName,(Length(FullName)-Position
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>(FullName,' ',Position(FullName,' ',1)+1))))
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#1920,4200><:f200,6Times New Roman,0,0,0>Once the entries in the FullName field are separated into first and last names, you can search or sort on either the First or Last fields. To add new names, continue to enter the full names in the FullName field. Approach wil
l automatically separate each new entry in the FullName field into the appropriate calculated field for the first name and last name.<:f200,FArial,0,0,0>
@Normal@<:R1,8,1,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,><:#336,4200><+!><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> <:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> Tip 4<:f200,2Tms Rmn,0,0,0>
@Normal@<:R><:#480,4200><+!><:f200,2Tms Rmn,0,0,0>Remove the Border and Row Lines from a Repeating Panel<-!><:f200,FArial,0,0,0>
@Normal@<:#720,4200><:f200,6Times New Roman,0,0,0>To display or print information from a repeating panel without lines between the rows and without border lines, do the following:
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@step@<:#480,4200>1. While in design, select the repeating panel with the right mouse button.
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>2. From the Style Menu, select Pen Color.
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>3. From the color palette, select N for none.
@step@<:#960,4200>4. Return to browse and notice that neither the row lines nor border lines are visible, but all the data is. Also, neither row lines nor border lines will print.
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#960,4200><:f200,6Times New Roman,0,0,0>See graphic on next page for an example. Duplicate repeating panels are shown. The first panel has pen color set to black; the second has pen color set to none.
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#336,4200><+!><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> Tip 5<-!><:f200,FArial,0,0,0>
@Normal@<:#480,4200><+!><:f200,2Tms Rmn,0,0,0><:f200,2Tms Rmn,0,0,0>Summing a Field Over Several Rows of a Repeating Panel<-!><:f200,FArial,0,0,0>
@Normal@<:#480,4200><:f200,6Times New Roman,0,0,0>Q. I have a numeric field in a repeating panel on an order
@Normal@<:#960,4200><:f200,6Times New Roman,0,0,0>form. Several line items for each order are listed in the repeating panel. How do I sum a field over all of the rows of a specific repeating panel and have that sum appear on the order form?
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#720,4200><:f200,6Times New Roman,0,0,0>A. Create a new summary calculation field which will sum the field and display the total on the order form:
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>1. Switch to design for your order form.
@step@<:#720,4200>2. Add a new calculated field which will compute the sum of the numeric field in the repeating panel.
@step@<:#960,4200>3. In the formula box for the calculated field enter: SSUM(field_name), where field_name is the name of the field in the repeating panel to be summed.
@step@<:#1200,4200>4. Set the Summarize On box to: Summary of all records from the database the repeating panel is based on. This selects only those records from the database the repeating panel is based on which relate to the current order
@step@<:#480,4200>5. Add this new summary calculation field to the order form, outside of the repeating panel.
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>See graphic below.
@Normal@<:R1,8,1,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,><:#336,4200><+!><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> <:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> Tip 6<-!><:f200,FArial,0,0,0>
@Normal@<:R><:#240,4200><+!><:f200,2Tms Rmn,0,0,0><:f200,2Tms Rmn,0,0,0>Adding a Row or Record to a Repeating Panel<-!><:f200,FArial,0,0,0>
@Normal@<:#1440,4200><:f200,6Times New Roman,0,0,0>For version 2.0 only, clicking within a field in the blank row following the last entry in a repeating panel adds a new record. Or, if the repeating panel is blank, click within a field in the top row. Adding data to the fiel
ds in this row adds a new record to the repeating panel.
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@Normal@<:R1,8,1,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,><:#336,4200><+!><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> <:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> Tip 7<:f200,2Tms Rmn,0,0,0>
@Normal@<:R><:#240,4200><+!><:f200,2Tms Rmn,0,0,0>Finding Blanks<-!><:f200,6Times New Roman,0,0,0>
@step@<:#720,4200>Q. I want to find all the records in my database where the STATE field is blank. How can I do this with Approach?
@Normal@<:#96,4200><:f80,6Times New Roman,0,0,0>
@step@<:#720,4200>A. Choose Find from the Records menu or click the Find Tool on the Approach tool bar. Click in the STATE field and type: =
@Normal@<:#1200,4200><:f200,6Times New Roman,0,0,0>Now press the enter key. Approach will find all records where the STATE field is blank. Typing only the equals sign (=) during a find request instructs Approach to search for blanks. To search for all non-blank entries type:
@Normal@<:R1,8,1,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,><:#336,4200><+!><:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> <:f280,2Tms Rmn,0,0,0><:f280,2Tms Rmn,0,0,0> Tip 8<:f200,2Tms Rmn,0,0,0>
@Normal@<:R><:#240,4200><+!><:f200,2Tms Rmn,0,0,0>Quickly Move to First or Last Record<-!><:f200,FArial,0,0,0>
@Normal@<:#480,4200><:f200,6Times New Roman,0,0,0>For optimal performance in moving between the first and last record of any found set:
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>1. First, switch to a Form View of the data.
@step@<:#720,4200>2. Either click the first or last record buttons on the Approach tool bar or choose First Record or Last Record from the Records menu.
@Normal@<:#231,4200><:f200,FArial,0,0,0>
@Normal@<:#231,4200><:f200,FArial,0,0,0>
@Normal@<:#231,4200><:f200,FArial,0,0,0>
@Normal@<:f200,FArial,0,0,0><:p</@>2>
@Normal@<:I360,0,0,504><:#2880,8640><:f200,6Times New Roman,0,0,0><**><:f200,6Times New Roman,0,0,0><**><:f200,6Times New Roman,0,0,0> <+!><:f200,6Times New Roman,0,0,0><:f200,6Times New Roman,0,0,0><**><:f200,6Times New Roman,0,0,0>A. Tip 6<-!><**><:f200,6Times New Roman,0,0,0>Click here to
add a new record to a Repeating Panel<**><+!><:f200,6Times New Roman,0,0,0>B. Tip 5<-!><**><:f200,6Times New Roman,0,0,0>SSUM(Amount) Summarize on ALL records in inventory. Repeating Panel is based on Inventory.<**><+!><:f200,6Times New Roman,0,0,0>C. T
ip 4<-!><**><:f200,6Times New Roman,0,0,0>Repeating Panel pen color set to Black.<**><+!><:f200,6Times New Roman,0,0,0>D. Tip 4<**><-!><:f200,6Times New Roman,0,0,0>Repeating Panel pen color set to None. <:f200,6Times New Roman,0,0,0>