Apache OpenOffice Community Forum - Tables & Queries

Tables & Queries

New Topic

1547 topics

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

Announcements

Replies

Views

Last post

Apache OpenOffice 4.1.12 released

Last post by robleyd « Thu May 05, 2022 2:15 am
Posted in Announcements

by robleyd » Thu May 05, 2022 2:15 am » in Announcements

0 Replies

5632 Views

Last post by robleyd
Thu May 05, 2022 2:15 am

Topics

Replies

Views

Last post

[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

303 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

277 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

262 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

743 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

964 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

566 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

940 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

1278 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

1173 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

628 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

1336 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

3132 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

3367 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

2051 Views

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

Last post by ablazquez « Wed Dec 01, 2021 9:33 pm
Replies: 1
by ablazquez » Fri Nov 26, 2021 12:14 pm

1 Replies

1771 Views

Last post by ablazquez
Wed Dec 01, 2021 9:33 pm
[Solved] Filter query by count on only one table

Last post by Doranwen « Sat Nov 27, 2021 2:41 am
Replies: 4
by Doranwen » Wed Nov 24, 2021 9:53 am

4 Replies

3026 Views

Last post by Doranwen
Sat Nov 27, 2021 2:41 am
[Solved] Clarification Split Data Base Class Path

Last post by Dalke55 « Fri Nov 12, 2021 9:59 pm
Replies: 3
by Dalke55 » Fri Nov 12, 2021 1:43 am

3 Replies

2639 Views

Last post by Dalke55
Fri Nov 12, 2021 9:59 pm
[Solved] How to JOIN 3 Tables?

Last post by Victor P « Thu Oct 28, 2021 8:18 am
Replies: 3
by Victor P » Wed Oct 27, 2021 12:45 pm

3 Replies

1886 Views

Last post by Victor P
Thu Oct 28, 2021 8:18 am
[Solved] Criteria error

Last post by gkick « Fri Oct 22, 2021 5:50 am
Replies: 2
by gkick » Fri Oct 22, 2021 3:56 am

2 Replies

1624 Views

Last post by gkick
Fri Oct 22, 2021 5:50 am
[Solved] Upgrade Split_HSQLDB 2.3.2 to 2.5.1

Last post by UnklDonald418 « Sun Sep 26, 2021 8:35 pm
Replies: 4
by Dalke55 » Sun Sep 26, 2021 1:05 am

4 Replies

2358 Views

Last post by UnklDonald418
Sun Sep 26, 2021 8:35 pm
[Solved] Base table with different background colors

Last post by Villeroy « Sun Sep 19, 2021 3:30 pm
Replies: 3
by Bugsie1977 » Sun Sep 19, 2021 11:55 am

3 Replies

1824 Views

Last post by Villeroy
Sun Sep 19, 2021 3:30 pm
[Solved] Subtract set value of hours from a Time Field

Last post by Dalke55 « Thu Sep 09, 2021 4:28 pm
Replies: 2
by Dalke55 » Thu Sep 09, 2021 2:39 am

2 Replies

2205 Views

Last post by Dalke55
Thu Sep 09, 2021 4:28 pm
[Solved] Subtract set value of hours from a Timestamp field

Last post by Dalke55 « Wed Sep 08, 2021 4:53 pm
Replies: 2
by Dalke55 » Wed Sep 08, 2021 2:38 am

2 Replies

1995 Views

Last post by Dalke55
Wed Sep 08, 2021 4:53 pm
Converting MS Access Query to OpenOffice Base Query

Last post by Villeroy « Wed Sep 08, 2021 3:19 pm
Replies: 7
by mciverp2 » Tue Sep 07, 2021 2:09 pm

7 Replies

2600 Views

Last post by Villeroy
Wed Sep 08, 2021 3:19 pm
Localization of queries

Last post by UnklDonald418 « Tue Aug 24, 2021 1:28 am
Replies: 7
by didier.besset » Thu Aug 19, 2021 11:14 am

7 Replies

3692 Views

Last post by UnklDonald418
Tue Aug 24, 2021 1:28 am
[Solved] How to find items that do not exist in a room?

Last post by gkick « Mon Aug 09, 2021 10:05 pm
Replies: 8
by gkick » Sat Aug 07, 2021 9:26 pm

8 Replies

3643 Views

Last post by gkick
Mon Aug 09, 2021 10:05 pm
Filter Data or Query in a Column

Last post by Villeroy « Sun Aug 08, 2021 6:42 pm
Replies: 1
by cbl » Sun Aug 08, 2021 3:29 pm

1 Replies

1575 Views

Last post by Villeroy
Sun Aug 08, 2021 6:42 pm
Help Moving Data from Spreadsheet into Base Table

Last post by Sliderule « Thu Aug 05, 2021 5:00 am
Replies: 12
by Needing Help » Sun Aug 01, 2021 9:52 pm

12 Replies

4762 Views

Last post by Sliderule
Thu Aug 05, 2021 5:00 am
Import Calc spreadsheet into a new table

Last post by Villeroy « Wed Jul 14, 2021 8:35 pm
Replies: 3
by tdrannon » Wed Jul 14, 2021 2:03 pm

3 Replies

2254 Views

Last post by Villeroy
Wed Jul 14, 2021 8:35 pm
New OO Base User QUERY design

Last post by ve4per_andy « Sat May 29, 2021 10:34 am
Replies: 6
by ve4per_andy » Thu May 27, 2021 11:25 pm

6 Replies

3208 Views

Last post by ve4per_andy
Sat May 29, 2021 10:34 am
[Solved] How to calculate cumulative values in queries

Last post by gkick « Thu May 27, 2021 6:15 am
Replies: 2
by gkick » Thu May 27, 2021 2:20 am

2 Replies

1899 Views

Last post by gkick
Thu May 27, 2021 6:15 am
[Solved] Multiple junction table entries in one row in query

Last post by Doranwen « Tue May 25, 2021 3:30 am
Replies: 9
by Doranwen » Sun May 23, 2021 11:47 pm

9 Replies

3617 Views

Last post by Doranwen
Tue May 25, 2021 3:30 am
[Solved] Modify timestamp via SQL and use in queries

Last post by Doranwen « Mon May 10, 2021 6:24 am
Replies: 5
by Doranwen » Sun May 09, 2021 6:46 pm

5 Replies

2899 Views

Last post by Doranwen
Mon May 10, 2021 6:24 am
Change Date and Change User

Last post by zizo « Wed Apr 07, 2021 2:42 pm
Replies: 7
by zizo » Mon Apr 05, 2021 2:46 pm

7 Replies

3358 Views

Last post by zizo
Wed Apr 07, 2021 2:42 pm
[Solved] Table already exists error in base

Last post by AkshatTumkur « Mon Mar 29, 2021 12:46 pm
Replies: 5
by AkshatTumkur » Mon Mar 29, 2021 11:49 am

5 Replies

2826 Views

Last post by AkshatTumkur
Mon Mar 29, 2021 12:46 pm
Creating Primary Key in a database from imported data

Last post by Villeroy « Mon Mar 01, 2021 6:08 pm
Replies: 9
by WabashCannonball » Fri Jan 26, 2018 12:10 am

9 Replies

5226 Views

Last post by Villeroy
Mon Mar 01, 2021 6:08 pm
[Solved] Adding two fields

Last post by crushedoreos « Tue Feb 23, 2021 8:00 pm
Replies: 3
by crushedoreos » Tue Feb 23, 2021 6:51 pm

3 Replies

2118 Views

Last post by crushedoreos
Tue Feb 23, 2021 8:00 pm
[Solved] Restrict query results based on OR possibilities

Last post by eremmel « Thu Feb 18, 2021 10:39 pm
Replies: 3
by Doranwen » Mon Jan 25, 2021 5:35 am

3 Replies

2484 Views

Last post by eremmel
Thu Feb 18, 2021 10:39 pm
SQL: Expect NULL but get zero

Last post by NeoOOUEU « Sun Feb 14, 2021 6:48 pm
Replies: 3
by NeoOOUEU » Thu Feb 11, 2021 9:39 pm

3 Replies

2473 Views

Last post by NeoOOUEU
Sun Feb 14, 2021 6:48 pm
Table not found in statement

Last post by Villeroy « Fri Feb 05, 2021 12:35 pm
Replies: 2
by VINEET JETHANI » Thu Feb 04, 2021 7:27 am

2 Replies

2089 Views

Last post by Villeroy
Fri Feb 05, 2021 12:35 pm
[Solved] Count query with junction tables, conditions, sort

Last post by Doranwen « Sat Jan 16, 2021 12:16 am
Replies: 7
by Doranwen » Fri Jan 15, 2021 9:08 am

7 Replies

3354 Views

Last post by Doranwen
Sat Jan 16, 2021 12:16 am
[Solved] Query with user input and code formatting

Last post by Villeroy « Thu Jan 07, 2021 9:37 pm
Replies: 5
by BrianME » Tue Jan 05, 2021 9:53 pm

5 Replies

2679 Views

Last post by Villeroy
Thu Jan 07, 2021 9:37 pm
[Solved] CASE statement returning nulls

Last post by dreamquartz « Wed Jan 06, 2021 5:49 pm
Replies: 3
by superfuntastic » Sat Jan 02, 2021 4:48 am

3 Replies

2513 Views

Last post by dreamquartz
Wed Jan 06, 2021 5:49 pm
Auto Filling fields from a different table

Last post by NevP « Wed Dec 16, 2020 1:26 am
Replies: 4
by NevP » Tue Dec 15, 2020 1:33 am

4 Replies

2859 Views

Last post by NevP
Wed Dec 16, 2020 1:26 am
Auto-Increment jumped by >2000

Last post by Villeroy « Tue Dec 15, 2020 11:58 am
Replies: 4
by the ber » Mon Dec 14, 2020 6:26 pm

4 Replies

2518 Views

Last post by Villeroy
Tue Dec 15, 2020 11:58 am
[Solved] Aggregate of subquery

Last post by StormWolf « Mon Dec 07, 2020 12:35 am
Replies: 1
by StormWolf » Sun Dec 06, 2020 11:59 pm

1 Replies

1941 Views

Last post by StormWolf
Mon Dec 07, 2020 12:35 am
[Solved] Subtraction in a query

Last post by StormWolf « Sun Dec 06, 2020 9:07 am
Replies: 4
by StormWolf » Sun Dec 06, 2020 2:08 am

4 Replies

2377 Views

Last post by StormWolf
Sun Dec 06, 2020 9:07 am
Create query with macro

Last post by UnklDonald418 « Thu Nov 26, 2020 7:06 pm
Replies: 3
by kevinT220 » Thu Nov 26, 2020 5:58 am

3 Replies

2300 Views

Last post by UnklDonald418
Thu Nov 26, 2020 7:06 pm
Problem in direct data entry

Last post by UnklDonald418 « Mon Nov 23, 2020 6:48 pm
Replies: 1
by megha bhavsar » Mon Nov 23, 2020 11:47 am

1 Replies

1834 Views

Last post by UnklDonald418
Mon Nov 23, 2020 6:48 pm
[Solved] Relationship design - one-to-one or giant table?

Last post by Doranwen « Sun Nov 08, 2020 9:14 pm
Replies: 19
by Doranwen » Fri Nov 06, 2020 9:35 pm

19 Replies

6748 Views

Last post by Doranwen
Sun Nov 08, 2020 9:14 pm

New Topic

1547 topics

Page 1 of 31
- Jump to page:
1
2
3
4
5
…
31
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