The tutorial above shows me how to calculate field results to obtain a billing amount, which gets me half-way (or more) to my goal. One of my first projects is to create a database that, among other things, allows me to collect and store time spent on legal matters. I am about to hang out my own shingle (legal practice) and plan to use OOo and other open-source programs rather than closed-source applications (such as MS Office and Timeslips). The information you share from time to time has helped me become more efficient in my use of OOo. Solveig, I appreciate the effort you put into your blog.
Create a mail merge of some sort based on the query.Right-click on the column heading and choose Column Format. You'll see your results, with the calculation.įor any of the columns, including the result, you can apply currency formatting. Then click the Run Query icon to run the query. In the cell below that, the cell to the right of the Alias label, type the name you want to use to refer to this calculated field, like TotalPaid. Type fieldname*fieldnameįor instance, to multiply the contents of Payrate by Hoursonjob, type To add the calculation, click in the top cell of the first blank column. It will appear in the design area at the bottom.Ĩ. Add all the fields that you want in the query - you might all of them.
The table will appear in its own separate window. In the window that appear, select the table that contains the fields you need to calculate and click Add.ħ. Click the Queries icon at the far left.Ħ. (File > New > Database, select the first radio button in that window and continue.)Ģ. The pay rate times the hours to equal the total amount paid, for instance.ġ. Now, let's say you want to figure out something based that data.
Invoice ID, Item price, Number of items purchased, etc. When you make a database, you of course have it chock full of data.Ĭontractor name, Contractor pay rate, Number of hours the contractor worked, etc.
0 kommentar(er)
