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.16 Released

Last post by robleyd « Thu Nov 13, 2025 3:27 am
Posted in Announcements
Replies: 1
by LastUnicorn » Tue Nov 11, 2025 12:36 pm » in Announcements

1 Replies

1878 Views

Last post by robleyd
Thu Nov 13, 2025 3:27 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

12774 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

2618 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

1603 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

1587 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

1661 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

5172 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

7759 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

29317 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

6951 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

8008 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

7652 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

9946 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

9021 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

10659 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

8362 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

22370 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

16868 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

21253 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

11305 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

11239 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

12665 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

9562 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

11804 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

12851 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

12673 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

11341 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

13687 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

9909 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

11376 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

10155 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

11854 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

10769 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

19566 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

13900 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

10640 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

10673 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

16572 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

10423 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

19147 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

12342 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

10056 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

11562 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

13525 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

11112 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

13497 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

12048 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

12863 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

10798 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

11900 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

12970 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