Re: [libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...

2020-09-07 Thread Robert Großkopf
Hi Zed, > > My first thought was to have the entire database in one Table, > differentiating the sectors by using different titles for the ID field, > e.g. ID as an Integer (for the Reactor), IDArtist  for the artist as an > Integer etc.  I created the IDArtist as an Integer but when I tried to >

Re: [libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...

2020-09-07 Thread zed
Using LibreOffice Base v6.4.5.2 on Linux Mint v20.0 Thanks to the assistance given by members of this Mailing List, I have made progress in creating a database using LibreOffice Base. I have created a database Reactor_Videos which has the fields (1) Reactor_Videos Table 1 ID Name (of

Re: [libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...

2020-08-02 Thread zed
Hi Robert On 2/08/20 6:37 pm, Robert Großkopf wrote: Hi Zed, The Table has one field named "Gender" and the gender is indicated by F, or M or M/F where a family is involved. What I was trying to achieve was a query which extracted the total numbers for each gender (e.g. 50, M25, M/F13)

Re: [libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...

2020-08-02 Thread Robert Großkopf
Hi Zed, > > The Table has one field named "Gender" and the gender is indicated by F, > or M or M/F where a family is involved. > > What I was trying to achieve was a query which extracted the total > numbers for each gender (e.g. 50, M25, M/F13) between a particular time > period. In this case

[libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...

2020-08-01 Thread zed
Attention: Robert Grosskopf My apologies for not following convention and replying in the normal manner but I rather foolishly deleted your advice by mistake, The information you gave me regarding my request for help on how to construct a query was just the guide I required to solve my

Re: [libreoffice-users] LibreOffice Base (previously copying data from Calc to Base)...

2020-08-01 Thread Robert Großkopf
Hi zed, > > Thank you for your very prompt reply. I followed your instructions and > it returned the sum of entries on the date entered. I obviously didn't > phrase my questions clearly enough, for what I wanted was the sum of all > entries for the period 01/07/2020 to 31/07/2020.  I cannot find

Re: [libreoffice-users] LibreOffice Base (previously copying data from Calc to Base)...

2020-07-31 Thread zed
On 1/08/20 2:14 pm, Dan Lewis wrote: Comments inline: On 7/31/20 20:14, zed wrote: Thank you to all the members who replied so promptly to my request for help.  It is very much appreciated. One member sent me advice of another method to achieve what I wanted and I am delighted to say it

Re: [libreoffice-users] LibreOffice Base (previously copying data from Calc to Base)...

2020-07-31 Thread Dan Lewis
Comments inline: On 7/31/20 20:14, zed wrote: Thank you to all the members who replied so promptly to my request for help.  It is very much appreciated. One member sent me advice of another method to achieve what I wanted and I am delighted to say it worked and I now have a database with the

[libreoffice-users] LibreOffice Base (previously copying data from Calc to Base)...

2020-07-31 Thread zed
Thank you to all the members who replied so promptly to my request for help. It is very much appreciated. One member sent me advice of another method to achieve what I wanted and I am delighted to say it worked and I now have a database with the fields I need, with one Table and one Form.