Concatenating data can increase readability and friendliness without losing a bit of functionality.

cialis tabs

It’s common to populate a list control with a SQL statement, especially if you want to concatenate fields. For instance, the following SQL statement displays a list of names in multiple columns:

SELECT EmployeeID, LastName, FirstName

FROM Employees

ORDER BY LastName

The control’s Column Count property is 3 and the Column Width property is 0. That way, the control can pass a record’s primary key value (EmployeeID) unseen.

The ORDER BY clause sorts the rows by LastName. The solution is typical, but Access can do better. We’re just not used to viewing names in columnar format. Concatenating the names into a single column, as follows, displays a more familiar format:

SELECT EmployeeID, LastName & ", " & FirstName

FROM Employees

ORDER BY LastName

I want to caution you against sorting on the concatenated field as follows:

SELECT EmployeeID, LastName & ", " & FirstName

FROM Employees

ORDER BY LastName & ", " & FirstName

It’ll work, but if the data source contains a lot of data, it won’t perform well. Sorting by individual columns is more efficient, especially if the fields are indexed; Jet can’t use an index against the concatenated results of the ORDER BY clause. Besides, it’s awkward and unnecessary. Just specify sort fields in the ORDER BY clause as you normally would — displaying concatenated data doesn’t change the way you sort.

There’s still a way to improve the display. Perhaps it really isn’t an improvement, but a different way to present the data. Transpose the names, displaying the first name first, in a more natural format. You can still sort by last names, as follows:

SELECT EmployeeID, FirstName & " " & LastName

FROM Employees

ORDER BY LastName

Don’t worry if a sort field isn’t in the SELECT clause’s field list — SQL doesn’t require that. SQL requires only that the sort field be in the underlying data source.

When you have a Word table that spans multiple pages, you’ll probably want the header row to appear at the top of each page. Luckily, repeating a heading row across several pages takes only a few quick clicks.

---

cialis tablets for sale width=”100%” size=”2″ />

Sometimes, what seems to be a difficult problem has an easy built-in solution. I ran into that recently with a Word table that was several pages long. Of course, I wanted to repeat the table’s header row at the top of each page. That way, readers didn’t have to return to the table’s first page to learn what type of data was in a particular column. I had to stop and think for a minute, as I couldn’t remember ever doing this before.

Customized menus make it easy to miss built-in features. If you don’t use the item occasionally, Word doesn’t display the item on the menu! It’s less than intuitive, but I went back to the Table menu and clicked the double arrow to display all the menu items and there it was — Heading Rows Repeat.

To use this feature, simply click inside the header row and choose Heading Rows Repeat from the Table menu. It couldn’t be simpler. Word then displays the heading row at the top of every page as long as the table continues.

You can easily add a custom form button that enables your users to choose which records to print. Mary Ann Richards steps through the process.

When you want to enable your users to print only the records they need, you can set up a form that lets them do just that. For example, to create a form that generates a report listing only the records of employees hired during a specific period, follow these steps:

1. Click the Text box tool in the Toolbar options box. (In Access 2007, click the Text box control on the Design tab.)

1. Click and drag to create the first unbound text box. Change the text box label to From:.

1. Click the Text Box tool in the Toolbar options box. (In Access 2007, click the Text Box control on the Design tab.)

1. Click and drag to create the second unbound text box. Change the text box label to To:.

1. Right-click the first text box and select Properties. Click the All tab and then click in the Name property box and type StartDate.

1. Right-click the second text box and select Properties. Click the All tab and then click in the Name property box and type EndDate.

1. Click the Command tool in the Toolbar Options box. (In Access 2007, click the Command control on the Design tab.)

1. Click and drag in the form to locate cialis soft the Command button. (Click Cancel to close the Command wizard, if necessary.)

1. Right-click the Command tool and then click Properties.

1. Click the All tab and then click in the Caption property box and type Print Report.

1. Click the Event tab.

1. Click the Build button in the On Click property box.

1. Click Event Procedure.

1. Enter the following code at the prompt, as shown in Figure A, and press Alt + Q:

Figure A

To use this form to generate a report for all employees hired from 2001 to 2003, you would enter 1/1/2001 in the From box and 1/1/2003 in the To box (Figure B). Then, just press the Print Report button.

Figure B

If you need to know how many words are in a document, and some of them are inside a text box, you’ll have to perform at least one extra step. Here’s a look at how to get the numbers you need.

The Word Count command in Word 2002/2003 excludes text boxes when totaling the number of words in your document. As Figure A shows, the Word Count dialog shows a count of 0, even though the document contains two linked text boxes filled with text.

Figure A

Since the text boxes are linked, you can find the number of words in those boxes by following cialis soft tabs vs cialis these steps:

1. Press Ctrl + A.

1. Go to Tools | Word Count.

The Word Count box now shows the correct number of Words in the text boxes, as shown in Figure B.

If the text boxes had not been linked, you would have needed to perform this operation on each box separately and then add the totals of each box to get a final count. Likewise, to calculate the total number of words in a document with one text box surrounded by other text, you would go to Tools | Word count to find the total for the surrounding text, follow steps 1 through 3 to find the total for the text box, and then add the two numbers for your total.

The spinner offers an easy way to test different input variables to see the effect on a financial model — without altering your underlying formulas. This example shows how to put this useful feature to work.

Sensitivity analysis determines how a spreadsheet’s outputs will vary in response to changes made to the spreadsheet’s inputs. Excel gives us a number of tools for sensitivity analysis. One of these is the spinner. A spinner is linked to a cell containing one of the variable inputs. As the user clicks on the spinner, the value of the linked cell changes.

For example, the following worksheet can be used to examine how changes in three variable cialis soft tabs online inputs (price, unit cost, and fixed cost) affect profit. To set up the formulas for the worksheet, follow these steps:

Figure A

1. Go to Tools | Options, click the Calculation tab, and then select the Accept Labels In Formulas check box. (In Excel 2007, click the Formulas tab, click Create From Selection in the Defined Names group, and then click OK.)
2. Enter 2 in cell D1, which is the current price.
3. Enter the rest of the formulas as shown in Figure B.

Figure B

1. Type Enter Unit Cost (in hundredths) in cell H1.
2. Type Enter Fixed Cost (in thousands) in cell H2.
3. Enter 44 in cell I1 (the current Unit Cost).
4. Enter 20 in cell I1 (the current Fixed Cost), as shown in Figure C.

Figure C

1. Go to View | Toolbars | Forms to display the Forms toolbar. (In Excel 2007, click the Developer tab.)
2. Click the Spinner button on the Forms toolbar. (In Excel 2007, click Insert in the Forms Group and then click the Spin button under Form Controls.)
3. Click and drag in cell F1 to create the Price spinner.
4. Repeat step 9 and then click and drag in cell F3 to create the Unit Cost spinner.
5. Repeat step 9 and then click and drag in cell F4 to create the Fixed Cost spinner.
6. Right-click the spinner in F1, click Format Control, and enter the values shown in Figure D.

Figure D

1. Right-click the spinner in F3, click Format Control, and enter the values shown in Figure E.

Figure E

1. Right-click the spinner in F4, click Format Control, and enter the values shown in Figure F.

Figure F

Your manager just learned that increases in material costs have raised the unit cost to .60. Using the spinner to adjust for this higher cost, the profit decreases to $45,800. Clicking the Price spinner up arrow once to raise the price to $3 immediately shows a drop in demand (assuming the demand formula is correct). However, even with this drop in demand, profit goes up significantly, which may warrant the price increase.