Apache OpenOffice Community Forum - Tables & Queries - (View forum)

Tables & Queries

New Topic

1586 topics

Page 2 of 32
- Jump to page:
Previous
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

330826 Views

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

Topics

Replies

Views

Last post

[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

12333 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

10338 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

13053 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

15213 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

11600 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

10649 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

6111 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

7817 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

6268 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

5711 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

4726 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

6097 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

5523 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

5623 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

5103 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

6080 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

6913 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

6515 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

2780 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

7277 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

3528 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

5052 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

3322 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

6557 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

7364 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

5323 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

4998 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

7637 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

3312 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

3790 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

4084 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

3117 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

5529 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

4295 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

3709 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

4658 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

3840 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

3372 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

3604 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

3570 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

2712 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

11540 Views

Last post by Doranwen
Sun Nov 08, 2020 9:14 pm
[Solved] Add a numbered field

Last post by Villeroy « Sat Oct 24, 2020 1:52 pm
Replies: 7
by GauSte » Tue Oct 20, 2020 11:43 pm

7 Replies

5298 Views

Last post by Villeroy
Sat Oct 24, 2020 1:52 pm
[Solved] String/Date Conversion (HSQL25.)

Last post by Villeroy « Thu Oct 01, 2020 7:42 am
Replies: 3
by gkick » Thu Oct 01, 2020 3:58 am

3 Replies

4048 Views

Last post by Villeroy
Thu Oct 01, 2020 7:42 am
Using same report for updated database

Last post by Villeroy « Mon Sep 28, 2020 6:48 pm
Replies: 4
by knight2 » Sun Sep 27, 2020 9:35 pm

4 Replies

3731 Views

Last post by Villeroy
Mon Sep 28, 2020 6:48 pm
[Solved] Problem in direct data entry

Last post by UnklDonald418 « Tue Sep 15, 2020 5:49 pm
Replies: 3
by meeranair2020 » Tue Sep 08, 2020 5:28 pm

3 Replies

3902 Views

Last post by UnklDonald418
Tue Sep 15, 2020 5:49 pm
[Solved] Setting a multifield constraint

Last post by gkick « Sat Sep 05, 2020 9:34 pm
Replies: 2
by gkick » Sat Sep 05, 2020 6:46 pm

2 Replies

3119 Views

Last post by gkick
Sat Sep 05, 2020 9:34 pm
[Solved] Average within dynamic daterange

Last post by gkick « Sat Aug 22, 2020 4:19 pm
Replies: 3
by gkick » Sat Aug 22, 2020 2:28 pm

3 Replies

3654 Views

Last post by gkick
Sat Aug 22, 2020 4:19 pm
[Solved] IF/THEN in a query criteria

Last post by asiegelson « Mon Aug 17, 2020 10:13 pm
Replies: 4
by asiegelson » Mon Aug 17, 2020 5:00 pm

4 Replies

4379 Views

Last post by asiegelson
Mon Aug 17, 2020 10:13 pm
Error inserting a new record (Null)

Last post by UnklDonald418 « Mon Aug 17, 2020 6:57 pm
Replies: 4
by Kzneft » Sun Aug 16, 2020 10:04 pm

4 Replies

5514 Views

Last post by UnklDonald418
Mon Aug 17, 2020 6:57 pm

New Topic

1586 topics

Page 2 of 32
- Jump to page:
Previous
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