User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
Tables & Queries
-
- Announcements
- Replies
- Views
- Last post
-
- Apache OpenOffice 4.1.7 released
by RoryOF » Sat Sep 21, 2019 10:47 pm - 0 Replies
- 115356 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Different behavior of IS NULL with LO and OO
by charlie.it » Thu Jul 02, 2020 4:28 pm - 14 Replies
- 875 Views
- Last post by charlie.it
Sun Jul 05, 2020 9:16 am
- [Solved] Different behavior of IS NULL with LO and OO
-
- [Solved] Help with temporary table (HSQL2.5)
by gkick » Thu Jun 04, 2020 10:17 pm
- 15 Replies
- 935 Views
- Last post by Sliderule
Sun Jun 07, 2020 11:42 pm
- [Solved] Help with temporary table (HSQL2.5)
-
- [SOLVED] Need Query to limt by last sale price of each item
by widowmaker » Fri May 22, 2020 6:15 pm
- 8 Replies
- 715 Views
- Last post by widowmaker
Fri May 29, 2020 3:04 pm
- [SOLVED] Need Query to limt by last sale price of each item
-
- Mutually Exclusive Check Boxes
by Mickey12 » Fri May 29, 2020 11:41 am - 2 Replies
- 146 Views
- Last post by robleyd
Fri May 29, 2020 12:30 pm
- Mutually Exclusive Check Boxes
-
- [Solved] Crosstab Query Help with Error
by gkick » Sun May 24, 2020 5:01 am
- 3 Replies
- 297 Views
- Last post by gkick
Mon May 25, 2020 12:09 am
- [Solved] Crosstab Query Help with Error
-
- [Solved] Help preventing deletion in a table or form via Tri
by gkick » Sat May 23, 2020 8:37 am - 3 Replies
- 265 Views
- Last post by gkick
Sat May 23, 2020 5:34 pm
- [Solved] Help preventing deletion in a table or form via Tri
-
- [Solved] SQL Query Comparing Strings
by JohnNorris » Thu May 07, 2020 1:47 am - 6 Replies
- 482 Views
- Last post by robleyd
Fri May 08, 2020 8:06 am
- [Solved] SQL Query Comparing Strings
-
- [Solved] Filtertable containing concatenated field
by gkick » Mon Apr 20, 2020 1:44 am - 0 Replies
- 343 Views
- Last post by gkick
Mon Apr 20, 2020 1:44 am
- [Solved] Filtertable containing concatenated field
-
- [Solved] CASE WHEN or sql loop?
by gkick » Sat Mar 28, 2020 7:14 am
- 3 Replies
- 573 Views
- Last post by gkick
Sun Mar 29, 2020 9:49 pm
- [Solved] CASE WHEN or sql loop?
-
- Creating a database
by cblumtritt@aol.com » Fri Mar 27, 2020 2:18 am - 1 Replies
- 295 Views
- Last post by robleyd
Fri Mar 27, 2020 2:50 am
- Creating a database
-
- [Solved] Populating filter table with date functions
by gkick » Wed Mar 18, 2020 6:36 am
- 13 Replies
- 946 Views
- Last post by gkick
Sat Mar 21, 2020 9:57 pm
- [Solved] Populating filter table with date functions
-
- [Solved] Negative parameter for query problem
by cwdavi1 » Thu Feb 13, 2020 10:40 pm - 4 Replies
- 767 Views
- Last post by Russ Ullman
Sat Feb 15, 2020 7:35 pm
- [Solved] Negative parameter for query problem
-
- [SOLVED] Cannot open table section
by brandobaris » Wed Jun 10, 2015 4:46 am - 3 Replies
- 1781 Views
- Last post by rulerofallchickens
Sun Feb 09, 2020 7:01 pm
- [SOLVED] Cannot open table section
-
- [Solved] Find session_user in HSQL2.5
by gkick » Tue Feb 04, 2020 6:13 am - 2 Replies
- 427 Views
- Last post by gkick
Tue Feb 04, 2020 1:21 pm
- [Solved] Find session_user in HSQL2.5
-
- Entering new data in a Query
by Ladybug1972 » Wed Jan 29, 2020 4:19 pm - 2 Replies
- 387 Views
- Last post by Villeroy
Wed Jan 29, 2020 6:06 pm
- Entering new data in a Query
-
- [Solved] Query inside select statement
by the ber » Mon Jan 27, 2020 12:38 pm - 3 Replies
- 427 Views
- Last post by the ber
Tue Jan 28, 2020 9:41 am
- [Solved] Query inside select statement
-
- How split multiple strings in a column
by arfgh » Thu Jan 16, 2020 12:53 am - 15 Replies
- 1130 Views
- Last post by Villeroy
Wed Jan 22, 2020 11:07 pm
- How split multiple strings in a column
-
- [Solved] Recurring query problem
by gkick » Thu Jan 16, 2020 3:14 pm - 9 Replies
- 598 Views
- Last post by chrisb
Fri Jan 17, 2020 2:22 pm
- [Solved] Recurring query problem
-
- [Solved] Primary Key not Saved
by rhammer54 » Sat Jan 04, 2020 2:40 pm - 5 Replies
- 624 Views
- Last post by rhammer54
Sun Jan 05, 2020 3:07 pm
- [Solved] Primary Key not Saved
-
- [Solved] Date Function ? Find specific days of week
by gkick » Mon Dec 23, 2019 8:52 pm - 12 Replies
- 1130 Views
- Last post by Villeroy
Sun Dec 29, 2019 6:07 pm
- [Solved] Date Function ? Find specific days of week
-
- [Solved] Timestampdate to string or number
by gkick » Sat Dec 28, 2019 5:19 am - 2 Replies
- 357 Views
- Last post by gkick
Sat Dec 28, 2019 12:19 pm
- [Solved] Timestampdate to string or number
-
- [Solved] Table/number formatting/currency does not stay
by Arbe » Thu Dec 26, 2019 4:20 am - 2 Replies
- 362 Views
- Last post by Arbe
Thu Dec 26, 2019 8:29 pm
- [Solved] Table/number formatting/currency does not stay
-
- [Solved] Maths or Logical Issue
by gkick » Sun Dec 22, 2019 4:08 am - 2 Replies
- 414 Views
- Last post by gkick
Sun Dec 22, 2019 4:59 am
- [Solved] Maths or Logical Issue
-
- [Solved]Converting timestamps
by gkick » Fri Dec 20, 2019 6:18 am - 3 Replies
- 420 Views
- Last post by gkick
Fri Dec 20, 2019 4:54 pm
- [Solved]Converting timestamps
-
- [Solved] Query extract size from last 2 numbers after dash
by cartoonjazz » Wed Dec 18, 2019 9:15 pm - 4 Replies
- 508 Views
- Last post by cartoonjazz
Thu Dec 19, 2019 5:51 pm
- [Solved] Query extract size from last 2 numbers after dash
-
- [Solved] Create query to show clients from specified city
by RosarioCarrillo » Thu Dec 05, 2019 8:07 am
- 16 Replies
- 1238 Views
- Last post by RosarioCarrillo
Fri Dec 06, 2019 9:05 am
- [Solved] Create query to show clients from specified city
-
- [Solved] SQL How to update current row
by gkick » Tue Nov 26, 2019 9:03 pm - 2 Replies
- 435 Views
- Last post by gkick
Tue Nov 26, 2019 10:02 pm
- [Solved] SQL How to update current row
-
- [Solved] Simple dumb? Can't use SaveAll...now! Export to CSV
by MSPhobe » Sun Mar 12, 2017 4:43 pm - 10 Replies
- 6018 Views
- Last post by doubleDog55
Mon Nov 18, 2019 5:56 pm
- [Solved] Simple dumb? Can't use SaveAll...now! Export to CSV
-
- [Solved] Need Help whether to have split database
by Registry » Thu Nov 07, 2019 5:25 pm
- 4 Replies
- 656 Views
- Last post by Registry
Sun Nov 10, 2019 1:52 pm
- [Solved] Need Help whether to have split database
-
- Dropdown list in query parameter input
by MHCom » Fri Nov 08, 2019 5:00 pm - 1 Replies
- 368 Views
- Last post by F3K Total
Fri Nov 08, 2019 5:51 pm
- Dropdown list in query parameter input
-
- [Solved] Additional auto increment on no pk
by gkick » Tue Nov 05, 2019 6:13 pm - 4 Replies
- 506 Views
- Last post by gkick
Fri Nov 08, 2019 5:12 am
- [Solved] Additional auto increment on no pk
-
- [SOLVED]Macro/Query Failure after updating to split database
by aterbo » Tue Oct 22, 2019 10:49 pm - 6 Replies
- 884 Views
- Last post by Villeroy
Thu Oct 24, 2019 1:06 pm
- [SOLVED]Macro/Query Failure after updating to split database
-
- [Solved] Size of backend db
by gkick » Thu Sep 26, 2019 9:42 pm
- 4 Replies
- 778 Views
- Last post by gkick
Fri Sep 27, 2019 4:29 am
- [Solved] Size of backend db
-
- Copied table from one odb file to another, tables linked
by cwdavi1 » Mon Sep 23, 2019 2:40 am - 3 Replies
- 542 Views
- Last post by UnklDonald418
Wed Sep 25, 2019 11:16 pm
- Copied table from one odb file to another, tables linked
-
- [Solved] Query that generates a progressive numbering
by charlie.it » Wed Sep 25, 2019 7:47 am
- 9 Replies
- 852 Views
- Last post by charlie.it
Wed Sep 25, 2019 10:48 pm
- [Solved] Query that generates a progressive numbering
-
- [Solved] How to display percentage in query
by gkick » Tue Sep 17, 2019 9:52 pm
- 14 Replies
- 1277 Views
- Last post by gkick
Mon Sep 23, 2019 4:53 pm
- [Solved] How to display percentage in query
-
- [Solved] Updating table with fields from another table
by cwdavi1 » Sat Sep 21, 2019 10:42 pm - 3 Replies
- 479 Views
- Last post by cwdavi1
Sun Sep 22, 2019 5:50 am
- [Solved] Updating table with fields from another table
-
- How to implement what MS calls "Autonumber" key field?
by JSSchiavo » Tue Feb 06, 2018 2:26 am - 5 Replies
- 2218 Views
- Last post by Nocton
Tue Sep 17, 2019 9:29 am
- How to implement what MS calls "Autonumber" key field?
-
- [Solved] Requesting help converting to split database
by Dalke55 » Wed Jul 10, 2019 12:09 pm
- 3 Replies
- 647 Views
- Last post by rwzelnick
Fri Sep 13, 2019 2:39 am
- [Solved] Requesting help converting to split database
-
- [Solved] DateCalc HSQL2.5 backend or H2 backend
by gkick » Thu Aug 29, 2019 5:56 pm - 10 Replies
- 1153 Views
- Last post by gkick
Fri Aug 30, 2019 5:20 pm
- [Solved] DateCalc HSQL2.5 backend or H2 backend
-
- [Solved] How does one query a multline column?
by gkick » Wed Aug 21, 2019 11:59 pm
- 3 Replies
- 736 Views
- Last post by gkick
Fri Aug 23, 2019 6:52 am
- [Solved] How does one query a multline column?
-
- [Solved] Union query alternatives
by gkick » Tue Aug 20, 2019 6:47 am
- 5 Replies
- 906 Views
- Last post by Sliderule
Tue Aug 20, 2019 7:38 pm
- [Solved] Union query alternatives
-
- [Solved] Query Syntax embedded versus backend db
by gkick » Sat Aug 10, 2019 8:44 am
- 8 Replies
- 1189 Views
- Last post by Villeroy
Thu Aug 15, 2019 5:53 pm
- [Solved] Query Syntax embedded versus backend db
-
- [Solved] SQL Syntax for SQL Newbie
by gkick » Wed Aug 07, 2019 5:41 pm - 2 Replies
- 601 Views
- Last post by gkick
Wed Aug 07, 2019 7:04 pm
- [Solved] SQL Syntax for SQL Newbie
-
- [Solved] Combine multiple rows into one in query results
by Doranwen » Thu Aug 01, 2019 2:22 am - 13 Replies
- 1863 Views
- Last post by Doranwen
Sat Aug 03, 2019 4:44 am
- [Solved] Combine multiple rows into one in query results
-
- [SOLVED] Query excluding criteria, multiple junction tables
by Doranwen » Wed Jul 31, 2019 4:49 am - 5 Replies
- 748 Views
- Last post by Doranwen
Thu Aug 01, 2019 2:03 am
- [SOLVED] Query excluding criteria, multiple junction tables
-
- How to import data from spreadsheet into existing table?
by adrian87 » Wed Jul 24, 2019 3:20 pm - 3 Replies
- 706 Views
- Last post by Villeroy
Wed Jul 24, 2019 6:40 pm
- How to import data from spreadsheet into existing table?
-
- LO/Firebird - subtraction issue and other operations
by pinco pallo » Wed Jul 10, 2019 4:31 pm
- 10 Replies
- 1136 Views
- Last post by Villeroy
Thu Jul 11, 2019 4:29 pm
- LO/Firebird - subtraction issue and other operations
-
- Creating ID# from 2 fields
by D Soyars » Sun Jun 30, 2019 4:20 pm - 3 Replies
- 831 Views
- Last post by UnklDonald418
Wed Jul 03, 2019 8:30 pm
- Creating ID# from 2 fields
-
- Date of created file
by D Soyars » Sun Jun 30, 2019 4:26 pm - 4 Replies
- 881 Views
- Last post by UnklDonald418
Wed Jul 03, 2019 5:37 pm
- Date of created file
Who is online
Users browsing this forum: No registered users and 2 guests
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
|
Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these Policies and Terms of Use |
Get OpenOffice
|