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.9 released
by robleyd » Mon Feb 08, 2021 7:55 am - 0 Replies
- 25161 Views
- Last post by robleyd
Mon Feb 08, 2021 7:55 am
- Apache OpenOffice 4.1.9 released
-
- Topics
- Replies
- Views
- Last post
-
- Change Date and Change User
by zizo » Mon Apr 05, 2021 2:46 pm
- 7 Replies
- 344 Views
- Last post by zizo
Wed Apr 07, 2021 2:42 pm
- Change Date and Change User
-
- [Solved] Table already exists error in base
by AkshatTumkur » Mon Mar 29, 2021 11:49 am
- 5 Replies
- 261 Views
- Last post by AkshatTumkur
Mon Mar 29, 2021 12:46 pm
- [Solved] Table already exists error in base
-
- Creating Primary Key in a database from imported data
by WabashCannonball » Fri Jan 26, 2018 12:10 am - 9 Replies
- 1896 Views
- Last post by Villeroy
Mon Mar 01, 2021 6:08 pm
- Creating Primary Key in a database from imported data
-
- [Solved] Adding two fields
by crushedoreos » Tue Feb 23, 2021 6:51 pm
- 3 Replies
- 301 Views
- Last post by crushedoreos
Tue Feb 23, 2021 8:00 pm
- [Solved] Adding two fields
-
- [Solved] Restrict query results based on OR possibilities
by Doranwen » Mon Jan 25, 2021 5:35 am - 3 Replies
- 544 Views
- Last post by eremmel
Thu Feb 18, 2021 10:39 pm
- [Solved] Restrict query results based on OR possibilities
-
- SQL: Expect NULL but get zero
by NeoOOUEU » Thu Feb 11, 2021 9:39 pm
- 3 Replies
- 424 Views
- Last post by NeoOOUEU
Sun Feb 14, 2021 6:48 pm
- SQL: Expect NULL but get zero
-
- Table not found in statement
by VINEET JETHANI » Thu Feb 04, 2021 7:27 am - 2 Replies
- 323 Views
- Last post by Villeroy
Fri Feb 05, 2021 12:35 pm
- Table not found in statement
-
- [Solved] Count query with junction tables, conditions, sort
by Doranwen » Fri Jan 15, 2021 9:08 am - 7 Replies
- 734 Views
- Last post by Doranwen
Sat Jan 16, 2021 12:16 am
- [Solved] Count query with junction tables, conditions, sort
-
- [Solved] Query with user input and code formatting
by BrianME » Tue Jan 05, 2021 9:53 pm - 5 Replies
- 545 Views
- Last post by Villeroy
Thu Jan 07, 2021 9:37 pm
- [Solved] Query with user input and code formatting
-
- [Solved] CASE statement returning nulls
by superfuntastic » Sat Jan 02, 2021 4:48 am - 3 Replies
- 438 Views
- Last post by dreamquartz
Wed Jan 06, 2021 5:49 pm
- [Solved] CASE statement returning nulls
-
- Auto Filling fields from a different table
by NevP » Tue Dec 15, 2020 1:33 am
- 4 Replies
- 608 Views
- Last post by NevP
Wed Dec 16, 2020 1:26 am
- Auto Filling fields from a different table
-
- Auto-Increment jumped by >2000
by the ber » Mon Dec 14, 2020 6:26 pm - 4 Replies
- 450 Views
- Last post by Villeroy
Tue Dec 15, 2020 11:58 am
- Auto-Increment jumped by >2000
-
- [Solved] Aggregate of subquery
by StormWolf » Sun Dec 06, 2020 11:59 pm - 1 Replies
- 389 Views
- Last post by StormWolf
Mon Dec 07, 2020 12:35 am
- [Solved] Aggregate of subquery
-
- [Solved] Subtraction in a query
by StormWolf » Sun Dec 06, 2020 2:08 am - 4 Replies
- 439 Views
- Last post by StormWolf
Sun Dec 06, 2020 9:07 am
- [Solved] Subtraction in a query
-
- Create query with macro
by kevinT220 » Thu Nov 26, 2020 5:58 am - 3 Replies
- 522 Views
- Last post by UnklDonald418
Thu Nov 26, 2020 7:06 pm
- Create query with macro
-
- Problem in direct data entry
by megha bhavsar » Mon Nov 23, 2020 11:47 am
- 1 Replies
- 275 Views
- Last post by UnklDonald418
Mon Nov 23, 2020 6:48 pm
- Problem in direct data entry
-
- [Solved] Relationship design - one-to-one or giant table?
by Doranwen » Fri Nov 06, 2020 9:35 pm
- 19 Replies
- 1415 Views
- Last post by Doranwen
Sun Nov 08, 2020 9:14 pm
- [Solved] Relationship design - one-to-one or giant table?
-
- [Solved] Add a numbered field
by GauSte » Tue Oct 20, 2020 11:43 pm - 7 Replies
- 1049 Views
- Last post by Villeroy
Sat Oct 24, 2020 1:52 pm
- [Solved] Add a numbered field
-
- [Solved] String/Date Conversion (HSQL25.)
by gkick » Thu Oct 01, 2020 3:58 am - 3 Replies
- 863 Views
- Last post by Villeroy
Thu Oct 01, 2020 7:42 am
- [Solved] String/Date Conversion (HSQL25.)
-
- Using same report for updated database
by knight2 » Sun Sep 27, 2020 9:35 pm - 4 Replies
- 712 Views
- Last post by Villeroy
Mon Sep 28, 2020 6:48 pm
- Using same report for updated database
-
- [Solved] Problem in direct data entry
by meeranair2020 » Tue Sep 08, 2020 5:28 pm - 3 Replies
- 914 Views
- Last post by UnklDonald418
Tue Sep 15, 2020 5:49 pm
- [Solved] Problem in direct data entry
-
- [Solved] Setting a multifield constraint
by gkick » Sat Sep 05, 2020 6:46 pm - 2 Replies
- 546 Views
- Last post by gkick
Sat Sep 05, 2020 9:34 pm
- [Solved] Setting a multifield constraint
-
- [Solved] Average within dynamic daterange
by gkick » Sat Aug 22, 2020 2:28 pm - 3 Replies
- 839 Views
- Last post by gkick
Sat Aug 22, 2020 4:19 pm
- [Solved] Average within dynamic daterange
-
- [Solved] IF/THEN in a query criteria
by asiegelson » Mon Aug 17, 2020 5:00 pm
- 4 Replies
- 824 Views
- Last post by asiegelson
Mon Aug 17, 2020 10:13 pm
- [Solved] IF/THEN in a query criteria
-
- Error inserting a new record (Null)
by Kzneft » Sun Aug 16, 2020 10:04 pm
- 4 Replies
- 870 Views
- Last post by UnklDonald418
Mon Aug 17, 2020 6:57 pm
- Error inserting a new record (Null)
-
- [Solved] Different behavior of IS NULL with LO and OO
by charlie.it » Thu Jul 02, 2020 4:28 pm - 14 Replies
- 2910 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
- 2854 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
- 2007 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
- 687 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
- 914 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
- 905 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
- 1409 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
- 673 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
- 27259 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
- 724 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
- 2362 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
- 1329 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
- 2191 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
- 838 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
- 799 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
- 902 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
- 2211 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
- 1327 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
- 1290 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
- 2235 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
- 710 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
- 856 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
- 798 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
- 803 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
- 976 Views
- Last post by cartoonjazz
Thu Dec 19, 2019 5:51 pm
- [Solved] Query extract size from last 2 numbers after dash
Who is online
Users browsing this forum: No registered users and 4 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
|