openoffice base tutorial calculated field

#OPENOFFICE BASE TUTORIAL CALCULATED FIELD PRO#
#OPENOFFICE BASE TUTORIAL CALCULATED FIELD MAC#

eg 'Field Name1' + 'Field Name2' in a third field = a simple sum. It just means I have to close the query before I can re-open it in edit (or design) view.Working on LibreOffice 4.4.5.2 / HSQLDB 1.8.0.10Ĭalculated fields are quite easy. Anyway, not to worry, I see the way it works. Datasheet view is of course what you see having run the query. In Access (sorry to mention that) there is a handy button that switches between datasheet view, design view and SQL view.

I'm talking about switching between datasheet view and design view. Once in design view, then there is a button that says 'switch design view on or off', but it doesn't actually do that - it just switches to SQL view, which is really an alternative design view. The design view can also be accessed by right-clicking the name of the query in the query list. With the query closed and listed under 'Queries', there is an Edit button that gives access to the design view of the query. With the query having been opened and being viewed, there's no button to switch back to design view. That's not how my version of Base (the latest) seems to work.

From the Menu: View -> Switch Design View On/Off.

I have no idea what you are talking about if you mean while creating a Query. Holylander wrote:Also, I'm finding it quite clumsy to switch between design and view modes.

Date / Time calculation: Please see the link below with my explanation, for an example.

But, you can perform the calculations on the data, either with a Query, or, a View - a pseudo-table - that does not contain data, but, retrieves data and can perform calculations

A Table stores the atomic data, so, calculations are not stored in the table.

Fields ( sometimes called Column ) names are 'wrapped' in double quotes ( ' ) rather than brackets.

a list and description may be found at either of these two:

Functions: to perform 'calculations' besides to +, -, /, *.

Let's break the question down into a few pieces: you can confirm this by looking at the bottom, on the status bar after opening your database file. I will assume, your database is the 'default'. Maybe somebody will come out with a Base for Dummies one day, or Wiley will produce a Base Bible.

#OPENOFFICE BASE TUTORIAL CALCULATED FIELD PRO#

My 10-year old FileMaker Pro 3 works fine, but the hardware it runs on is not going to last much longer. I could use a new version of FileMaker Pro, but that's a big investment for the simple things I want to do.

#OPENOFFICE BASE TUTORIAL CALCULATED FIELD MAC#

That's a shame, as I want to use my Mac and not be forced to use Access on a PC. I suppose my conclusion is that Base is not intuitive enough for end users to work with and maybe you already have to be an expert to do anything. There's just no way of knowing what I'm doing wrong. I eventually found the CURDATE() function on the web (instead of Access's Date()), but I could not even get an expression like 'CURDATE() - AcquisitionDate' to work in a query. In Access I was able to build a function 'PresentValue: *(1-((Date()-MainTable!AcquisitionDate)/365.25)/)', but nothing works in Base. I then tried to replicate the process in Open Office and despite crawling over the limited help pages and the web generally, I got nowhere. For practice, I quickly built what I wanted in MS Access (which worked), although I fail to see why calculations only work in Access queries in not in tables. Thanks, Kabing, but I've spent many hours sweating with this and have got nowhere.

Openoffice base tutorial calculated field