Apache OpenOffice Community Forum - Tables & Queries

Tables & Queries

New Topic

1587 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

52609 Views

Last post by robleyd
Thu Nov 13, 2025 3:27 am

Topics

Replies

Views

Last post

Incorrect formatting of address labels 8162

Last post by RoryOF « Mon Dec 29, 2025 12:04 pm
Replies: 1
by Bty4821 » Sun Dec 28, 2025 9:43 pm

1 Replies

3255 Views

Last post by RoryOF
Mon Dec 29, 2025 12:04 pm
[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

14518 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

4088 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

3035 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

3014 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

3042 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

6517 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

9174 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

31113 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

8361 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

9446 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

9007 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

11451 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

10513 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

12126 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

9868 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

23773 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

18605 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

22734 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

12798 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

12898 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

14222 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

10941 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

13345 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

14310 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

14115 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

12828 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

15190 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

11309 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

12839 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

11621 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

13294 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

12207 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

21003 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

15560 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

12082 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

12163 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

18617 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

11844 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

20816 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

13927 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

11474 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

13040 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

15092 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

12490 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

14911 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

13490 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

14476 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

12167 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

13394 Views

Last post by syp1977
Tue Feb 22, 2022 12:12 pm

New Topic

1587 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