Apache OpenOffice Community Forum - Tables & Queries

Tables & Queries

New Topic

1586 topics

Page 1 of 32
- Jump to page:
1
2
3
4
5
…
32
Next

Announcements

Replies

Views

Last post

Apache OpenOffice 4.1.15 released

Last post by robleyd « Sat Dec 23, 2023 3:55 am
Posted in Announcements

by robleyd » Sat Dec 23, 2023 3:55 am » in Announcements

0 Replies

330740 Views

Last post by robleyd
Sat Dec 23, 2023 3:55 am

Topics

Replies

Views

Last post

[Solved] Update discriptions of records in tables

Last post by Rizwan Akhtar « Fri Oct 03, 2025 7:53 am
Replies: 8
by dreamquartz » Wed Dec 11, 2024 11:06 pm

8 Replies

12584 Views

Last post by Rizwan Akhtar
Fri Oct 03, 2025 7:53 am
[Solved] Aggregate data using two junction tables

Last post by Doranwen « Sat Aug 23, 2025 6:15 pm
Replies: 3
by Doranwen » Sat Aug 16, 2025 7:04 am

3 Replies

2499 Views

Last post by Doranwen
Sat Aug 23, 2025 6:15 pm
[Solved] WHILE ROLLUP in base parser, or alternative

Last post by Sliderule « Thu Aug 14, 2025 3:53 pm
Replies: 3
by Nikos » Wed Aug 13, 2025 12:52 pm

3 Replies

1514 Views

Last post by Sliderule
Thu Aug 14, 2025 3:53 pm
[Solved] Sum sets of fields separately in a single query

Last post by UnklDonald418 « Mon Aug 04, 2025 4:56 am
Replies: 5
by Doranwen » Sat Aug 02, 2025 5:52 am

5 Replies

1524 Views

Last post by UnklDonald418
Mon Aug 04, 2025 4:56 am
[Solved] Filter table before counting records on junction tables

Last post by Doranwen « Sat Aug 02, 2025 5:14 am
Replies: 4
by Doranwen » Sun Jul 27, 2025 11:31 am

4 Replies

1590 Views

Last post by Doranwen
Sat Aug 02, 2025 5:14 am
[Solved] Create columns with the result of a query

Last post by mikebd « Mon Dec 02, 2024 8:07 pm
Replies: 2
by mikebd » Sat Nov 30, 2024 2:40 pm

2 Replies

5104 Views

Last post by mikebd
Mon Dec 02, 2024 8:07 pm
[Solved] Alter field names of table

Last post by keme « Sun Jul 28, 2024 7:09 pm
Replies: 2
by aquadonia » Mon Jul 22, 2024 10:16 pm

2 Replies

7680 Views

Last post by keme
Sun Jul 28, 2024 7:09 pm
Dropdown list in query parameter input

Last post by MrProgrammer « Sat Jul 27, 2024 3:25 pm
Replies: 13
by MHCom » Fri Nov 08, 2019 5:00 pm

13 Replies

29041 Views

Last post by MrProgrammer
Sat Jul 27, 2024 3:25 pm
Unable to run aggregate function with 2 tables

Last post by FJCC « Sun Jul 14, 2024 7:32 pm
Replies: 1
by Mr.Dandy » Sun Jul 14, 2024 5:57 pm

1 Replies

6901 Views

Last post by FJCC
Sun Jul 14, 2024 7:32 pm
Number lessons in a schedule

Last post by HaraldS « Sun May 05, 2024 12:48 pm
Replies: 2
by HaraldS » Sat May 04, 2024 12:05 am

2 Replies

7925 Views

Last post by HaraldS
Sun May 05, 2024 12:48 pm
[Solved] Form from Query - Numeric field entered as Currency Field

Last post by Dalke55 « Sun Apr 21, 2024 7:08 pm
Replies: 2
by Dalke55 » Sat Apr 13, 2024 1:00 am

2 Replies

7580 Views

Last post by Dalke55
Sun Apr 21, 2024 7:08 pm
[Solved] Add a value to results of a query

Last post by Babayaga « Mon Mar 25, 2024 2:33 pm
Replies: 10
by Babayaga » Fri Mar 22, 2024 9:11 pm

10 Replies

9851 Views

Last post by Babayaga
Mon Mar 25, 2024 2:33 pm
[Solved] Subtraction in a simple query

Last post by Babayaga « Fri Mar 22, 2024 3:06 pm
Replies: 8
by Babayaga » Tue Mar 19, 2024 11:33 pm

8 Replies

8942 Views

Last post by Babayaga
Fri Mar 22, 2024 3:06 pm
[Solved] SQL Query: Need "Time" + "MinuteLen" as "EndTime"

Last post by Panaiotis82 « Wed Mar 20, 2024 7:52 pm
Replies: 10
by Panaiotis82 » Tue Mar 19, 2024 6:00 pm

10 Replies

10548 Views

Last post by Panaiotis82
Wed Mar 20, 2024 7:52 pm
[Solved] Create report with "Comments" filled in

Last post by MFL_2024 « Sun Mar 17, 2024 7:45 pm
Replies: 3
by MFL_2024 » Sat Mar 16, 2024 7:22 pm

3 Replies

8285 Views

Last post by MFL_2024
Sun Mar 17, 2024 7:45 pm
[Solved] Seeking assistance to configure SQL query

Last post by cjrc « Thu Jan 11, 2024 8:27 pm
Replies: 2
by cjrc » Wed Jan 10, 2024 9:49 pm

2 Replies

21439 Views

Last post by cjrc
Thu Jan 11, 2024 8:27 pm
[Solved] Syntax error if query run from F5 Edit window

Last post by charlie.it « Mon Oct 30, 2023 12:29 pm
Replies: 6
by charlie.it » Fri Oct 27, 2023 8:41 am

6 Replies

16620 Views

Last post by charlie.it
Mon Oct 30, 2023 12:29 pm
[Solved] Query dates by month

Last post by robleyd « Wed Oct 18, 2023 1:18 pm
Replies: 9
by younghammer » Mon Jun 25, 2012 11:57 pm

9 Replies

21138 Views

Last post by robleyd
Wed Oct 18, 2023 1:18 pm
[Solved] Data content could not be loaded / Single value expected

Last post by FDB « Tue Oct 17, 2023 3:49 pm
Replies: 2
by FDB » Tue Oct 17, 2023 3:18 pm

2 Replies

11224 Views

Last post by FDB
Tue Oct 17, 2023 3:49 pm
Query Add Table Greyed Out

Last post by Synapsis « Fri Sep 29, 2023 3:00 pm
Replies: 9
by Synapsis » Thu Sep 28, 2023 2:09 pm

9 Replies

11110 Views

Last post by Synapsis
Fri Sep 29, 2023 3:00 pm
SQL Alias Syntax for SubQuery in LibreOffice Base

Last post by UnklDonald418 « Sun Jun 25, 2023 6:54 am
Replies: 5
by LOn00bie » Thu Jun 15, 2023 3:32 pm

5 Replies

12547 Views

Last post by UnklDonald418
Sun Jun 25, 2023 6:54 am
View with parameters, the parser does not ask for parameters

Last post by Villeroy « Thu Jun 22, 2023 12:41 pm
Replies: 1
by Hypno » Thu Jun 22, 2023 10:29 am

1 Replies

9509 Views

Last post by Villeroy
Thu Jun 22, 2023 12:41 pm
[Solved] Query - Type of empty column

Last post by Cazer « Thu Jun 01, 2023 9:52 am
Replies: 7
by Hypno » Thu May 25, 2023 1:34 pm

7 Replies

11708 Views

Last post by Cazer
Thu Jun 01, 2023 9:52 am
[Solved] SQL: youngest and oldest with additional conditions and grouping

Last post by Villeroy « Tue May 30, 2023 10:04 pm
Replies: 6
by Hypno » Tue May 30, 2023 9:22 am

6 Replies

12735 Views

Last post by Villeroy
Tue May 30, 2023 10:04 pm
SQL result type CASE WHEN... THEN... expected as a date but is integer

Last post by Cazer « Mon May 29, 2023 4:50 pm
Replies: 7
by Hypno » Fri May 26, 2023 10:50 am

7 Replies

12556 Views

Last post by Cazer
Mon May 29, 2023 4:50 pm
[Solved] SQL Query Datediff Displaying Multiple Fields In Month

Last post by mkeeper « Sun Mar 05, 2023 10:25 am
Replies: 4
by mkeeper » Sat Mar 04, 2023 8:21 am

4 Replies

11248 Views

Last post by mkeeper
Sun Mar 05, 2023 10:25 am
Insert Row in Base table

Last post by technoweary « Sat Feb 18, 2023 12:16 pm
Replies: 7
by technoweary » Thu Feb 16, 2023 2:20 pm

7 Replies

13588 Views

Last post by technoweary
Sat Feb 18, 2023 12:16 pm
I want to show a single row

Last post by UnklDonald418 « Wed Feb 01, 2023 9:52 pm
Replies: 2
by AbdulHaseeb » Tue Jan 31, 2023 7:14 pm

2 Replies

9835 Views

Last post by UnklDonald418
Wed Feb 01, 2023 9:52 pm
Reports Aren't Sorting Correctly

Last post by UnklDonald418 « Tue Jan 10, 2023 12:49 am
Replies: 7
by DatabaseNewbie » Sun Jan 08, 2023 3:50 am

7 Replies

11283 Views

Last post by UnklDonald418
Tue Jan 10, 2023 12:49 am
[Solved] Query Month & Date from multiple years

Last post by Dalke55 « Mon Jan 09, 2023 4:08 am
Replies: 2
by Dalke55 » Sun Jan 08, 2023 1:39 am

2 Replies

10060 Views

Last post by Dalke55
Mon Jan 09, 2023 4:08 am
[Solved] Using WHERE changing column results in queries

Last post by DatabaseNewbie « Sat Jan 07, 2023 6:50 pm
Replies: 2
by DatabaseNewbie » Sat Jan 07, 2023 5:25 am

2 Replies

11774 Views

Last post by DatabaseNewbie
Sat Jan 07, 2023 6:50 pm
[Solved] Primary Key(s) using two fields

Last post by JakeRogers « Wed Dec 21, 2022 3:11 pm
Replies: 4
by JakeRogers » Wed Dec 21, 2022 2:59 am

4 Replies

10689 Views

Last post by JakeRogers
Wed Dec 21, 2022 3:11 pm
[Solved] Table not found in statement

Last post by Sliderule « Mon Dec 12, 2022 4:14 pm
Replies: 5
by Skrag » Mon Jul 24, 2017 7:34 pm

5 Replies

19436 Views

Last post by Sliderule
Mon Dec 12, 2022 4:14 pm
SQL query with IS LIKE clause - and user entry

Last post by Mountaineer « Mon Dec 12, 2022 10:00 am
Replies: 11
by Got_LibreOffice » Sat Dec 10, 2022 9:35 am

11 Replies

13789 Views

Last post by Mountaineer
Mon Dec 12, 2022 10:00 am
[Solved] Text wrapping option in Table column?

Last post by Got_LibreOffice « Fri Dec 09, 2022 6:13 pm
Replies: 5
by Got_LibreOffice » Fri Dec 09, 2022 4:13 am

5 Replies

10537 Views

Last post by Got_LibreOffice
Fri Dec 09, 2022 6:13 pm
Field name limited to 10 characters only

Last post by UnklDonald418 « Tue Nov 15, 2022 11:36 pm
Replies: 3
by divyan@2001 » Tue Nov 15, 2022 6:06 pm

3 Replies

10594 Views

Last post by UnklDonald418
Tue Nov 15, 2022 11:36 pm
[Solved] Error while creating a table with SQL commands

Last post by UnklDonald418 « Sat Oct 29, 2022 8:13 pm
Replies: 5
by Kartik Pachlodkar » Thu Oct 27, 2022 3:08 pm

5 Replies

16005 Views

Last post by UnklDonald418
Sat Oct 29, 2022 8:13 pm
[Solved] How do i use a criterion of today minus 7 days in base query?

Last post by guff54 « Sun Sep 11, 2022 4:56 pm
Replies: 2
by guff54 » Sat Sep 10, 2022 12:34 am

2 Replies

10345 Views

Last post by guff54
Sun Sep 11, 2022 4:56 pm
[Solved] TRUNCATE TABLE statement not recognized

Last post by tomaszwinnicki « Thu Aug 18, 2022 8:20 pm
Replies: 8
by assa » Thu Jan 11, 2018 7:26 am

8 Replies

19025 Views

Last post by tomaszwinnicki
Thu Aug 18, 2022 8:20 pm
[Solved] Count attributes from records in joined table

Last post by eremmel « Fri Jul 29, 2022 2:35 pm
Replies: 7
by John Riviera » Wed Jul 27, 2022 2:52 pm

7 Replies

12205 Views

Last post by eremmel
Fri Jul 29, 2022 2:35 pm
Re-arrange fields

Last post by UnklDonald418 « Fri Jul 22, 2022 6:44 pm
Replies: 2
by JohnKnee » Thu Jul 21, 2022 11:01 pm

2 Replies

9981 Views

Last post by UnklDonald418
Fri Jul 22, 2022 6:44 pm
[Solved] How to update an embedded HSQL table from another?

Last post by Villeroy « Fri Jul 15, 2022 2:34 pm
Replies: 4
by Villeroy » Wed Jul 13, 2022 1:47 pm

4 Replies

11464 Views

Last post by Villeroy
Fri Jul 15, 2022 2:34 pm
[Solved] Full join with complicated queries?

Last post by Doranwen « Wed Jun 15, 2022 4:28 am
Replies: 7
by Doranwen » Tue Jun 14, 2022 6:20 pm

7 Replies

13417 Views

Last post by Doranwen
Wed Jun 15, 2022 4:28 am
How to install and use pyodbc package with OpenOffice

Last post by Mountaineer « Mon May 16, 2022 7:40 am
Replies: 2
by b_peter_7 » Sun May 15, 2022 8:54 pm

2 Replies

11023 Views

Last post by Mountaineer
Mon May 16, 2022 7:40 am
*.odb with ODBC connection - The data content could not be loaded

Last post by b_peter_7 « Sun May 15, 2022 5:25 pm
Replies: 3
by b_peter_7 » Sun May 15, 2022 3:07 am

3 Replies

13420 Views

Last post by b_peter_7
Sun May 15, 2022 5:25 pm
[Solved] Need help with query to Calc

Last post by blkhrsrdr « Wed Apr 27, 2022 7:26 pm
Replies: 5
by blkhrsrdr » Wed Apr 27, 2022 2:05 am

5 Replies

11982 Views

Last post by blkhrsrdr
Wed Apr 27, 2022 7:26 pm
[Solved] Add multiples primary keys in GUI

Last post by LeadHead « Mon Apr 04, 2022 8:29 am
Replies: 4
by LeadHead » Sat Mar 12, 2022 11:42 am

4 Replies

12756 Views

Last post by LeadHead
Mon Apr 04, 2022 8:29 am
Query Re listing Text column associated with number column

Last post by chrisb « Fri Mar 18, 2022 3:03 am
Replies: 1
by StormWolf » Thu Mar 17, 2022 11:36 pm

1 Replies

10729 Views

Last post by chrisb
Fri Mar 18, 2022 3:03 am
[Solved] Error in query using where clause of split database

Last post by syp1977 « Tue Feb 22, 2022 12:12 pm
Replies: 3
by syp1977 » Mon Feb 21, 2022 10:27 am

3 Replies

11821 Views

Last post by syp1977
Tue Feb 22, 2022 12:12 pm
[Solved] Determine elapsed time between two button clicks

Last post by Villeroy « Thu Jan 27, 2022 3:01 pm
Replies: 7
by Korsakoffy » Wed Jan 26, 2022 8:45 pm

7 Replies

12865 Views

Last post by Villeroy
Thu Jan 27, 2022 3:01 pm

New Topic

1586 topics

Page 1 of 32
- Jump to page:
1
2
3
4
5
…
32
Next

Return to Board Index

Forum permissions

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum