Apache OpenOffice Community Forum - Tables & Queries

Tables & Queries

New Topic

1582 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

300255 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 dreamquartz « Wed Dec 25, 2024 11:41 pm
Replies: 4
by dreamquartz » Wed Dec 11, 2024 11:06 pm

4 Replies

9473 Views

Last post by dreamquartz
Wed Dec 25, 2024 11:41 pm
[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

4321 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

6768 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

27805 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

6068 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

7090 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

6728 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

8856 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

8000 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

9506 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

7401 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

20569 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

15629 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

20159 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

10369 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

10168 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

11584 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

8687 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

10918 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

11733 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

11555 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

10289 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

12508 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

8958 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

10350 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

9201 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

10930 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

9818 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

18469 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

12760 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

9642 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

9688 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

14455 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

9468 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

18058 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

11168 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

9107 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

10588 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

12494 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

10077 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

12501 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

11119 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

11825 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

9879 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

10934 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

11982 Views

Last post by Villeroy
Thu Jan 27, 2022 3:01 pm
[Solved] Help with SQL statement optimisation

Last post by eremmel « Sat Jan 15, 2022 10:26 pm
Replies: 7
by gkick » Wed Jan 12, 2022 5:13 pm

7 Replies

12029 Views

Last post by eremmel
Sat Jan 15, 2022 10:26 pm
[Solved] Query functions menu (GROUP, etc) not accessible

Last post by Fernando Exel « Mon Jan 10, 2022 1:27 am
Replies: 2
by Fernando Exel » Sun Jan 09, 2022 3:28 am

2 Replies

10124 Views

Last post by Fernando Exel
Mon Jan 10, 2022 1:27 am
Query for get consolidated data of particular item

Last post by syp1977 « Fri Jan 07, 2022 7:39 pm
Replies: 7
by syp1977 » Mon Jan 03, 2022 7:20 pm

7 Replies

12767 Views

Last post by syp1977
Fri Jan 07, 2022 7:39 pm
[Solved] Error Message with Query execution - inventory data

Last post by chrisb « Wed Dec 29, 2021 6:49 pm
Replies: 8
by syp1977 » Wed Nov 24, 2021 8:51 pm

8 Replies

14899 Views

Last post by chrisb
Wed Dec 29, 2021 6:49 pm

New Topic

1582 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