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

Tables & Queries

New Topic

1586 topics

Page 3 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] Different behavior of IS NULL with LO and OO

Last post by charlie.it « Sun Jul 05, 2020 9:16 am
Replies: 14
by charlie.it » Thu Jul 02, 2020 4:28 pm

14 Replies

9262 Views

Last post by charlie.it
Sun Jul 05, 2020 9:16 am
[Solved] Help with temporary table (HSQL2.5)

Last post by Sliderule « Sun Jun 07, 2020 11:42 pm
Replies: 15
by gkick » Thu Jun 04, 2020 10:17 pm

15 Replies

10516 Views

Last post by Sliderule
Sun Jun 07, 2020 11:42 pm
[SOLVED] Need Query to limt by last sale price of each item

Last post by widowmaker « Fri May 29, 2020 3:04 pm
Replies: 8
by widowmaker » Fri May 22, 2020 6:15 pm

8 Replies

6415 Views

Last post by widowmaker
Fri May 29, 2020 3:04 pm
Mutually Exclusive Check Boxes

Last post by robleyd « Fri May 29, 2020 12:30 pm
Replies: 2
by Mickey12 » Fri May 29, 2020 11:41 am

2 Replies

3248 Views

Last post by robleyd
Fri May 29, 2020 12:30 pm
[Solved] Crosstab Query Help with Error

Last post by gkick « Mon May 25, 2020 12:09 am
Replies: 3
by gkick » Sun May 24, 2020 5:01 am

3 Replies

3652 Views

Last post by gkick
Mon May 25, 2020 12:09 am
[Solved] Help preventing deletion in a table or form via Tri

Last post by gkick « Sat May 23, 2020 5:34 pm
Replies: 3
by gkick » Sat May 23, 2020 8:37 am

3 Replies

3633 Views

Last post by gkick
Sat May 23, 2020 5:34 pm
[Solved] SQL Query Comparing Strings

Last post by robleyd « Fri May 08, 2020 8:06 am
Replies: 6
by JohnNorris » Thu May 07, 2020 1:47 am

6 Replies

6017 Views

Last post by robleyd
Fri May 08, 2020 8:06 am
[Solved] Filtertable containing concatenated field

Last post by gkick « Mon Apr 20, 2020 1:44 am

by gkick » Mon Apr 20, 2020 1:44 am

0 Replies

2566 Views

Last post by gkick
Mon Apr 20, 2020 1:44 am
[Solved] CASE WHEN or sql loop?

Last post by gkick « Sun Mar 29, 2020 9:49 pm
Replies: 3
by gkick » Sat Mar 28, 2020 7:14 am

3 Replies

29779 Views

Last post by gkick
Sun Mar 29, 2020 9:49 pm
Creating a database

Last post by robleyd « Fri Mar 27, 2020 2:50 am
Replies: 1
by cblumtritt@aol.com » Fri Mar 27, 2020 2:18 am

1 Replies

2562 Views

Last post by robleyd
Fri Mar 27, 2020 2:50 am
[Solved] Populating filter table with date functions

Last post by gkick « Sat Mar 21, 2020 9:57 pm
Replies: 13
by gkick » Wed Mar 18, 2020 6:36 am

13 Replies

7121 Views

Last post by gkick
Sat Mar 21, 2020 9:57 pm
[Solved] Negative parameter for query problem

Last post by Russ Ullman « Sat Feb 15, 2020 7:35 pm
Replies: 4
by cwdavi1 » Thu Feb 13, 2020 10:40 pm

4 Replies

3572 Views

Last post by Russ Ullman
Sat Feb 15, 2020 7:35 pm
[SOLVED] Cannot open table section

Last post by rulerofallchickens « Sun Feb 09, 2020 7:01 pm
Replies: 3
by brandobaris » Wed Jun 10, 2015 4:46 am

3 Replies

5291 Views

Last post by rulerofallchickens
Sun Feb 09, 2020 7:01 pm
[Solved] Find session_user in HSQL2.5

Last post by gkick « Tue Feb 04, 2020 1:21 pm
Replies: 2
by gkick » Tue Feb 04, 2020 6:13 am

2 Replies

2433 Views

Last post by gkick
Tue Feb 04, 2020 1:21 pm
Entering new data in a Query

Last post by Villeroy « Wed Jan 29, 2020 6:06 pm
Replies: 2
by Ladybug1972 » Wed Jan 29, 2020 4:19 pm

2 Replies

2418 Views

Last post by Villeroy
Wed Jan 29, 2020 6:06 pm
[Solved] Query inside select statement

Last post by the ber « Tue Jan 28, 2020 9:41 am
Replies: 3
by the ber » Mon Jan 27, 2020 12:38 pm

3 Replies

2939 Views

Last post by the ber
Tue Jan 28, 2020 9:41 am
Split multiple strings in a column

Last post by Villeroy « Wed Jan 22, 2020 11:07 pm
Replies: 14
by arfgh » Thu Jan 16, 2020 12:53 am

14 Replies

7372 Views

Last post by Villeroy
Wed Jan 22, 2020 11:07 pm
[Solved] Recurring query problem

Last post by chrisb « Fri Jan 17, 2020 2:22 pm
Replies: 9
by gkick » Thu Jan 16, 2020 3:14 pm

9 Replies

3881 Views

Last post by chrisb
Fri Jan 17, 2020 2:22 pm
[Solved] Primary Key not Saved

Last post by rhammer54 « Sun Jan 05, 2020 3:07 pm
Replies: 5
by rhammer54 » Sat Jan 04, 2020 2:40 pm

5 Replies

3665 Views

Last post by rhammer54
Sun Jan 05, 2020 3:07 pm
[Solved] Date Function ? Find specific days of week

Last post by Villeroy « Sun Dec 29, 2019 6:07 pm
Replies: 12
by gkick » Mon Dec 23, 2019 8:52 pm

12 Replies

5646 Views

Last post by Villeroy
Sun Dec 29, 2019 6:07 pm
[Solved] Timestampdate to string or number

Last post by gkick « Sat Dec 28, 2019 12:19 pm
Replies: 2
by gkick » Sat Dec 28, 2019 5:19 am

2 Replies

2130 Views

Last post by gkick
Sat Dec 28, 2019 12:19 pm
[Solved] Table/number formatting/currency does not stay

Last post by Arbe « Thu Dec 26, 2019 8:29 pm
Replies: 2
by Arbe » Thu Dec 26, 2019 4:20 am

2 Replies

2767 Views

Last post by Arbe
Thu Dec 26, 2019 8:29 pm
[Solved] Maths or Logical Issue

Last post by gkick « Sun Dec 22, 2019 4:59 am
Replies: 2
by gkick » Sun Dec 22, 2019 4:08 am

2 Replies

2045 Views

Last post by gkick
Sun Dec 22, 2019 4:59 am
[Solved]Converting timestamps

Last post by gkick « Fri Dec 20, 2019 4:54 pm
Replies: 3
by gkick » Fri Dec 20, 2019 6:18 am

3 Replies

2140 Views

Last post by gkick
Fri Dec 20, 2019 4:54 pm
[Solved] Query extract size from last 2 numbers after dash

Last post by cartoonjazz « Thu Dec 19, 2019 5:51 pm
Replies: 4
by cartoonjazz » Wed Dec 18, 2019 9:15 pm

4 Replies

2539 Views

Last post by cartoonjazz
Thu Dec 19, 2019 5:51 pm
[Solved] Create query to show clients from specified city

Last post by RosarioCarrillo « Fri Dec 06, 2019 9:05 am
Replies: 16
by RosarioCarrillo » Thu Dec 05, 2019 8:07 am

16 Replies

5765 Views

Last post by RosarioCarrillo
Fri Dec 06, 2019 9:05 am
[Solved] SQL How to update current row

Last post by gkick « Tue Nov 26, 2019 10:02 pm
Replies: 2
by gkick » Tue Nov 26, 2019 9:03 pm

2 Replies

1754 Views

Last post by gkick
Tue Nov 26, 2019 10:02 pm
[Solved] Simple dumb? Can't use SaveAll...now! Export to CSV

Last post by doubleDog55 « Mon Nov 18, 2019 5:56 pm
Replies: 10
by MSPhobe » Sun Mar 12, 2017 4:43 pm

10 Replies

11424 Views

Last post by doubleDog55
Mon Nov 18, 2019 5:56 pm
[Solved] Need Help whether to have split database

Last post by Registry « Sun Nov 10, 2019 1:52 pm
Replies: 4
by Registry » Thu Nov 07, 2019 5:25 pm

4 Replies

2773 Views

Last post by Registry
Sun Nov 10, 2019 1:52 pm
[Solved] Additional auto increment on no pk

Last post by gkick « Fri Nov 08, 2019 5:12 am
Replies: 4
by gkick » Tue Nov 05, 2019 6:13 pm

4 Replies

2366 Views

Last post by gkick
Fri Nov 08, 2019 5:12 am
[SOLVED]Macro/Query Failure after updating to split database

Last post by Villeroy « Thu Oct 24, 2019 1:06 pm
Replies: 6
by aterbo » Tue Oct 22, 2019 10:49 pm

6 Replies

3259 Views

Last post by Villeroy
Thu Oct 24, 2019 1:06 pm
[Solved] Size of backend db

Last post by gkick « Fri Sep 27, 2019 4:29 am
Replies: 4
by gkick » Thu Sep 26, 2019 9:42 pm

4 Replies

2674 Views

Last post by gkick
Fri Sep 27, 2019 4:29 am
Copied table from one odb file to another, tables linked

Last post by UnklDonald418 « Wed Sep 25, 2019 11:16 pm
Replies: 3
by cwdavi1 » Mon Sep 23, 2019 2:40 am

3 Replies

2430 Views

Last post by UnklDonald418
Wed Sep 25, 2019 11:16 pm
[Solved] Query that generates a progressive numbering

Last post by charlie.it « Wed Sep 25, 2019 10:48 pm
Replies: 9
by charlie.it » Wed Sep 25, 2019 7:47 am

9 Replies

4251 Views

Last post by charlie.it
Wed Sep 25, 2019 10:48 pm
[Solved] How to display percentage in query

Last post by gkick « Mon Sep 23, 2019 4:53 pm
Replies: 14
by gkick » Tue Sep 17, 2019 9:52 pm

14 Replies

5950 Views

Last post by gkick
Mon Sep 23, 2019 4:53 pm
[Solved] Updating table with fields from another table

Last post by cwdavi1 « Sun Sep 22, 2019 5:50 am
Replies: 3
by cwdavi1 » Sat Sep 21, 2019 10:42 pm

3 Replies

4283 Views

Last post by cwdavi1
Sun Sep 22, 2019 5:50 am
How to implement what MS calls "Autonumber" key field?

Last post by Nocton « Tue Sep 17, 2019 9:29 am
Replies: 5
by JSSchiavo » Tue Feb 06, 2018 2:26 am

5 Replies

6788 Views

Last post by Nocton
Tue Sep 17, 2019 9:29 am
[Solved] Requesting help converting to split database

Last post by rwzelnick « Fri Sep 13, 2019 2:39 am
Replies: 3
by Dalke55 » Wed Jul 10, 2019 12:09 pm

3 Replies

2661 Views

Last post by rwzelnick
Fri Sep 13, 2019 2:39 am
[Solved] DateCalc HSQL2.5 backend or H2 backend

Last post by gkick « Fri Aug 30, 2019 5:20 pm
Replies: 10
by gkick » Thu Aug 29, 2019 5:56 pm

10 Replies

5329 Views

Last post by gkick
Fri Aug 30, 2019 5:20 pm
[Solved] How does one query a multline column?

Last post by gkick « Fri Aug 23, 2019 6:52 am
Replies: 3
by gkick » Wed Aug 21, 2019 11:59 pm

3 Replies

2717 Views

Last post by gkick
Fri Aug 23, 2019 6:52 am
[Solved] Union query alternatives

Last post by Sliderule « Tue Aug 20, 2019 7:38 pm
Replies: 5
by gkick » Tue Aug 20, 2019 6:47 am

5 Replies

6038 Views

Last post by Sliderule
Tue Aug 20, 2019 7:38 pm
[Solved] Query Syntax embedded versus backend db

Last post by Villeroy « Thu Aug 15, 2019 5:53 pm
Replies: 8
by gkick » Sat Aug 10, 2019 8:44 am

8 Replies

4590 Views

Last post by Villeroy
Thu Aug 15, 2019 5:53 pm
[Solved] SQL Syntax for SQL Newbie

Last post by gkick « Wed Aug 07, 2019 7:04 pm
Replies: 2
by gkick » Wed Aug 07, 2019 5:41 pm

2 Replies

2495 Views

Last post by gkick
Wed Aug 07, 2019 7:04 pm
[Solved] Combine multiple rows into one in query results

Last post by Doranwen « Sat Aug 03, 2019 4:44 am
Replies: 13
by Doranwen » Thu Aug 01, 2019 2:22 am

13 Replies

38485 Views

Last post by Doranwen
Sat Aug 03, 2019 4:44 am
[Solved] Query excluding criteria, multiple junction tables

Last post by Doranwen « Thu Aug 01, 2019 2:03 am
Replies: 5
by Doranwen » Wed Jul 31, 2019 4:49 am

5 Replies

4492 Views

Last post by Doranwen
Thu Aug 01, 2019 2:03 am
How to import data from spreadsheet into existing table?

Last post by Villeroy « Wed Jul 24, 2019 6:40 pm
Replies: 3
by adrian87 » Wed Jul 24, 2019 3:20 pm

3 Replies

6544 Views

Last post by Villeroy
Wed Jul 24, 2019 6:40 pm
LO/Firebird - subtraction issue and other operations

Last post by Villeroy « Thu Jul 11, 2019 4:29 pm
Replies: 10
by pinco pallo » Wed Jul 10, 2019 4:31 pm

10 Replies

5164 Views

Last post by Villeroy
Thu Jul 11, 2019 4:29 pm
Creating ID# from 2 fields

Last post by UnklDonald418 « Wed Jul 03, 2019 8:30 pm
Replies: 3
by D Soyars » Sun Jun 30, 2019 4:20 pm

3 Replies

3377 Views

Last post by UnklDonald418
Wed Jul 03, 2019 8:30 pm
Date of created file

Last post by UnklDonald418 « Wed Jul 03, 2019 5:37 pm
Replies: 4
by D Soyars » Sun Jun 30, 2019 4:26 pm

4 Replies

3332 Views

Last post by UnklDonald418
Wed Jul 03, 2019 5:37 pm
Group_Concat Producing Duplicates

Last post by UnklDonald418 « Thu Jun 20, 2019 7:50 pm
Replies: 1
by shock3 » Thu Jun 20, 2019 1:35 am

1 Replies

1813 Views

Last post by UnklDonald418
Thu Jun 20, 2019 7:50 pm

New Topic

1586 topics

Page 3 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