Here's what it looks like, with nothing done to it, in the database view. Here's a spreadsheet with =NOW() showing the absolutely current time and date. Can you use the =NOW() function in a spreadsheet and have it interpreted correctly in the database and in mail merges? (Thanks to a Colorado Springs LUG member for this idea.) The answer is Yes.
In the window that appears, right-click on the column heading, choose Column Format as before.Īnd in the window that appears, as before, make the choice you want. odb file, click the Tables or the Queries icon at the left, then double-click on the particular table (the sheet or query). You can do the same thing in the database file itself. Then in the window that appears you can select a category (Currency, Date, Number) and the the specific format you want. Then just right-click on the column heading and choose Column Format. Press F4 and expand to view the query or table you want. One way to do this is just set the formats when you view them. So if you want your Salary field to have dollar signs, decimals, etc.
Here are a couple things about formats, though.įormats don't come through. You create a spreadsheet of data, then choose File > New > Database, specify connecting to an existing database, Spreadsheet as the type, then click Next and point to the database itself.
Mail merges work fine with spreadsheets as the data source.
0 kommentar(er)
