Apache OpenOffice Community Forum - Tables & Queries

Tables & Queries

New Topic

1580 topics

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

Announcements

Replies

Views

Last post

Using a Gmail address for the forum account: workaround

Last post by floris v « Sun Apr 28, 2024 11:55 pm
Posted in Site Feedback
Replies: 1
by Hagar Delest » Tue Apr 23, 2024 11:13 am » in Site Feedback

1 Replies

111634 Views

Last post by floris v
Sun Apr 28, 2024 11:55 pm
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

145835 Views

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

Topics

Replies

Views

Last post

[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

2763 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

22895 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

2215 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

3184 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

2933 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

4164 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

3654 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

3774 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

3358 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

13077 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

11238 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

15851 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

6441 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

5890 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

7327 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

4838 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

6537 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

7130 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

6871 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

6276 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

7647 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

5081 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

6202 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

5294 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

6843 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

5716 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

13885 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

7964 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

5583 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

5675 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

9303 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

5638 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

12571 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

6793 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

5239 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

6496 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

8162 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

6058 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

8341 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

6983 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

7765 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

5973 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

6897 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

7721 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

7846 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

6054 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

7720 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

9939 Views

Last post by chrisb
Wed Dec 29, 2021 6:49 pm
Can I add fields to an existing table?

Last post by Villeroy « Thu Dec 16, 2021 7:24 pm
Replies: 6
by LizH » Fri May 04, 2018 9:28 pm

6 Replies

10914 Views

Last post by Villeroy
Thu Dec 16, 2021 7:24 pm
Updating Table from another table

Last post by chrisb « Sun Dec 12, 2021 12:39 pm
Replies: 10
by Prashant Kumar » Wed Dec 08, 2021 7:53 am

10 Replies

9941 Views

Last post by chrisb
Sun Dec 12, 2021 12:39 pm

New Topic

1580 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