Re: [libreoffice-users] Summing currency fields in base

2018-10-13 Thread Dan Lewis
Perhaps you need to begin over as far as you fields are concerned. First of all, you only need two fields in the table: Fee1 and Fee2. You also need a primary key which is listed first. Fee1 and fee2 need to be given the properties you want for them. The primary key has to have "entry

Re: [libreoffice-users] Summing currency fields in base

2018-10-13 Thread Adam Fenn
> On 11 Oct 2018, at 23:39, Girvin Herr wrote: > > I am not sure where you are wanting this total. I want it in the same form as fee1 and fee2. > First, you need to create a query, I'm familiar with this. > Then you need to have your form attach itself to the query rather than the >

Re: [libreoffice-users] Summing currency fields in base

2018-10-11 Thread Girvin Herr
Adam, I am not sure where you are wanting this total. There may be other methods to do this, but I prefer to do this calculation in a query. I use separate queries for reports and forms so a change in one does not affect the other. First, you need to create a query, if you have never created

Re: [libreoffice-users] Summing currency fields in base

2018-10-11 Thread Wade Smart
Ah, sorry. I cant see the whole subject line on my phone. Though a quick search on calculated fields shows you can: http://sheepdogguides.com/fdb/fdb1calcf1.htm -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Thu, Oct 11, 2018 at 2:00 PM Adam Fenn

Re: [libreoffice-users] Summing currency fields in base

2018-10-11 Thread Dave Howorth
On Thu, 11 Oct 2018 13:52:15 -0500 Wade Smart wrote: > If A1 is fee1 > fee2 is B1 > then in > c1 you type > =A1+B1 You do realize the question is about base, not calc? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Summing currency fields in base

2018-10-11 Thread Wade Smart
If A1 is fee1 fee2 is B1 then in c1 you type =A1+B1 -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Thu, Oct 11, 2018 at 1:51 PM Adam Fenn wrote: > > Thanks Wade, but where do I put that? > > > On 11 Oct 2018, at 19:45, Wade Smart wrote: > > > > In

Re: [libreoffice-users] Summing currency fields in base

2018-10-11 Thread Adam Fenn
Thanks Wade, but where do I put that? > On 11 Oct 2018, at 19:45, Wade Smart wrote: > > In field 3 > =field1+field2 > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > On Thu, Oct 11, 2018 at 1:41 PM Adam Fenn wrote: >> >> I have three

Fwd: [libreoffice-users] Summing currency fields in base

2018-10-11 Thread Wade Smart
In field 3 =field1+field2 -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Thu, Oct 11, 2018 at 1:41 PM Adam Fenn wrote: > > I have three currency fields - 'Fee1', 'Fee2' and 'Total'. How do I add fee1 > and fee2 together and put the result

[libreoffice-users] Summing currency fields in base

2018-10-11 Thread Adam Fenn
I have three currency fields - 'Fee1', 'Fee2' and 'Total'. How do I add fee1 and fee2 together and put the result automatically into the Total field? TIA Adam. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?