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.6 released
by robleyd » Mon Nov 19, 2018 1:52 am - 0 Replies
- 78877 Views
- Last post by robleyd
Mon Nov 19, 2018 1:52 am
- Apache OpenOffice 4.1.6 released
-
- Topics
- Replies
- Views
- Last post
-
- [Solved] Query Syntax embedded versus backend db
by gkick » Sat Aug 10, 2019 8:44 am
- 8 Replies
- 321 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
- 133 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
- 334 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
- 185 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
- 177 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
- 375 Views
- Last post by Villeroy
Thu Jul 11, 2019 4:29 pm
- LO/Firebird - subtraction issue and other operations
-
- [Solved] Requesting help converting to split database
by Dalke55 » Wed Jul 10, 2019 12:09 pm
- 2 Replies
- 130 Views
- Last post by Dalke55
Wed Jul 10, 2019 7:21 pm
- [Solved] Requesting help converting to split database
-
- Creating ID# from 2 fields
by D Soyars » Sun Jun 30, 2019 4:20 pm - 3 Replies
- 388 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
- 412 Views
- Last post by UnklDonald418
Wed Jul 03, 2019 5:37 pm
- Date of created file
-
- Group_Concat Producing Duplicates
by shock3 » Thu Jun 20, 2019 1:35 am
- 1 Replies
- 236 Views
- Last post by UnklDonald418
Thu Jun 20, 2019 7:50 pm
- Group_Concat Producing Duplicates
-
- [Solved] OO Wiki tutorial problem.
by magnoliasouth » Wed Jun 19, 2019 9:07 pm - 3 Replies
- 146 Views
- Last post by magnoliasouth
Wed Jun 19, 2019 10:54 pm
- [Solved] OO Wiki tutorial problem.
-
- [Solved] Combine first and last name into one field
by RBromer » Fri May 31, 2019 5:31 pm - 2 Replies
- 305 Views
- Last post by RBromer
Fri May 31, 2019 6:38 pm
- [Solved] Combine first and last name into one field
-
- [Solved] Phantom records in data tables
by schadecp » Wed May 08, 2019 8:16 pm
- 14 Replies
- 820 Views
- Last post by schadecp
Tue May 14, 2019 3:14 am
- [Solved] Phantom records in data tables
-
- Integers and decimals together
by capemayal1 » Sun Apr 28, 2019 4:30 am - 6 Replies
- 442 Views
- Last post by Villeroy
Sun Apr 28, 2019 7:37 pm
- Integers and decimals together
-
- [Solved] Access is denied: Session is closed
by dpark29 » Sat Apr 20, 2019 7:32 pm - 3 Replies
- 296 Views
- Last post by dpark29
Sat Apr 20, 2019 8:45 pm
- [Solved] Access is denied: Session is closed
-
- Help with WHERE clause syntax in SQL
by JWB23 » Fri Apr 19, 2019 7:19 pm - 2 Replies
- 184 Views
- Last post by Villeroy
Fri Apr 19, 2019 8:32 pm
- Help with WHERE clause syntax in SQL
-
- [Solved] Many to many to many relationships
by thetallguyuk » Mon Apr 15, 2019 9:11 pm - 3 Replies
- 269 Views
- Last post by thetallguyuk
Tue Apr 16, 2019 9:52 pm
- [Solved] Many to many to many relationships
-
- [Solved] Autoincrement part of composite key
by xkanuk » Tue Feb 26, 2019 8:38 am - 6 Replies
- 799 Views
- Last post by Villeroy
Wed Feb 27, 2019 4:55 pm
- [Solved] Autoincrement part of composite key
-
- Problem with months_between
by Krishna1944 » Tue Feb 19, 2019 4:30 am - 1 Replies
- 306 Views
- Last post by Villeroy
Tue Feb 19, 2019 10:59 am
- Problem with months_between
-
- DATEADD problem ?
by arfgh » Thu Apr 14, 2016 3:05 pm
- 22 Replies
- 7591 Views
- Last post by Villeroy
Mon Feb 18, 2019 11:40 pm
- DATEADD problem ?
-
- [Solved] Query to return age as of December 31
by dpark29 » Tue Jan 22, 2019 9:45 pm - 2 Replies
- 426 Views
- Last post by dpark29
Tue Jan 22, 2019 10:13 pm
- [Solved] Query to return age as of December 31
-
- SQL obtain all lines ?
by arfgh » Sat Jan 05, 2019 4:04 pm
- 17 Replies
- 1070 Views
- Last post by arfgh
Sat Jan 12, 2019 2:02 pm
- SQL obtain all lines ?
-
- Concatenation
by capemayal1 » Wed Jan 09, 2019 4:56 pm - 1 Replies
- 242 Views
- Last post by FJCC
Wed Jan 09, 2019 5:44 pm
- Concatenation
-
- open office base 4
by acd » Mon Dec 31, 2018 7:39 am - 1 Replies
- 304 Views
- Last post by robleyd
Mon Dec 31, 2018 10:07 am
- open office base 4
-
- [Solved] Criteria filter in result
by christos73 » Fri Dec 21, 2018 1:18 am
- 8 Replies
- 691 Views
- Last post by christos73
Sun Dec 23, 2018 2:08 am
- [Solved] Criteria filter in result
-
- Query to pull dates from table
by AmyBUK » Mon Dec 17, 2018 3:57 pm
- 7 Replies
- 682 Views
- Last post by Villeroy
Tue Dec 18, 2018 9:48 pm
- Query to pull dates from table
-
- [Solved] filtering last entry of each location
by msahines » Wed Dec 12, 2018 4:13 am - 2 Replies
- 306 Views
- Last post by msahines
Wed Dec 12, 2018 5:44 am
- [Solved] filtering last entry of each location
-
- [Solved] Query Base for character in the column
by cub001 » Sun Dec 02, 2018 6:59 am
- 20 Replies
- 992 Views
- Last post by cub001
Thu Dec 06, 2018 12:17 am
- [Solved] Query Base for character in the column
-
- [Solved] Table not visible w/ timestamp data type w/MySQL
by mehorter » Mon Nov 19, 2018 11:34 pm
- 5 Replies
- 736 Views
- Last post by mehorter
Sun Nov 25, 2018 3:41 am
- [Solved] Table not visible w/ timestamp data type w/MySQL
-
- [Solved] Counting Number in Each Category
by peanuttt » Thu Nov 22, 2018 5:22 pm - 1 Replies
- 334 Views
- Last post by UnklDonald418
Fri Nov 23, 2018 4:06 am
- [Solved] Counting Number in Each Category
-
- [Solved] Can I start SQL from command line and pass commands
by Jerold » Tue Nov 20, 2018 9:43 pm - 5 Replies
- 583 Views
- Last post by Villeroy
Tue Nov 20, 2018 11:44 pm
- [Solved] Can I start SQL from command line and pass commands
-
- [Solved] Query criteria using AND on the same field
by AmyBUK » Tue Nov 13, 2018 2:16 pm
- 12 Replies
- 998 Views
- Last post by AmyBUK
Wed Nov 14, 2018 4:24 pm
- [Solved] Query criteria using AND on the same field
-
- [SOLVED] "out of memory"
by Jerold » Mon Nov 12, 2018 8:44 pm - 1 Replies
- 374 Views
- Last post by RusselB
Mon Nov 12, 2018 9:52 pm
- [SOLVED] "out of memory"
-
- [Solved] Using Alias filed within a query
by Maax555 » Fri Oct 05, 2018 1:47 pm - 4 Replies
- 883 Views
- Last post by Maax555
Tue Oct 23, 2018 10:38 am
- [Solved] Using Alias filed within a query
-
- [Solved] Where used for queries
by Maax555 » Mon Oct 22, 2018 3:20 pm - 3 Replies
- 514 Views
- Last post by Maax555
Tue Oct 23, 2018 10:27 am
- [Solved] Where used for queries
-
- [Solved] Automatically applying filters to table controls
by heebiejeebies » Mon Oct 08, 2018 4:13 am - 2 Replies
- 670 Views
- Last post by heebiejeebies
Wed Oct 10, 2018 1:15 am
- [Solved] Automatically applying filters to table controls
-
- [Solved] Adding two fields on a form
by Maax555 » Thu Oct 04, 2018 4:51 pm - 3 Replies
- 570 Views
- Last post by UnklDonald418
Fri Oct 05, 2018 6:26 pm
- [Solved] Adding two fields on a form
-
- Macro for "GenerateParcels" button.
by cjcesconetti » Wed Oct 03, 2018 2:00 am - 1 Replies
- 433 Views
- Last post by UnklDonald418
Wed Oct 03, 2018 9:36 pm
- Macro for "GenerateParcels" button.
-
- [Solved] Convert a new record form to an edit record form?
by Maax555 » Fri Sep 07, 2018 2:53 pm
- 29 Replies
- 2391 Views
- Last post by Maax555
Thu Sep 27, 2018 10:35 am
- [Solved] Convert a new record form to an edit record form?
-
- [Solved] Creating a query of two tables without repeating...
by PunkintheGutter » Wed Sep 19, 2018 6:46 pm
- 3 Replies
- 619 Views
- Last post by PunkintheGutter
Sun Sep 23, 2018 8:56 am
- [Solved] Creating a query of two tables without repeating...
-
- [Solved] Cannot save a carriage return in a Query
by det » Thu Sep 20, 2018 9:33 pm - 2 Replies
- 429 Views
- Last post by det
Thu Sep 20, 2018 10:30 pm
- [Solved] Cannot save a carriage return in a Query
-
- Computing membership expiration dates
by phollox » Thu Sep 13, 2018 6:59 am - 8 Replies
- 926 Views
- Last post by Villeroy
Sat Sep 15, 2018 7:39 pm
- Computing membership expiration dates
-
- [Solved] Delete all records from a table
by Maax555 » Wed Sep 05, 2018 1:06 pm - 4 Replies
- 916 Views
- Last post by Maax555
Thu Sep 06, 2018 9:15 am
- [Solved] Delete all records from a table
-
- [Solved] New Query gives error message
by baxtec » Mon Aug 06, 2018 12:50 pm
- 4 Replies
- 1181 Views
- Last post by baxtec
Mon Aug 06, 2018 9:41 pm
- [Solved] New Query gives error message
-
- Pulling data from second table
by doubletrack » Mon Jul 30, 2018 6:26 pm
- 2 Replies
- 663 Views
- Last post by doubletrack
Tue Jul 31, 2018 12:28 am
- Pulling data from second table
-
- How to edit my ODB file
by AsherRuchie » Wed Aug 23, 2017 12:32 am - 11 Replies
- 4226 Views
- Last post by Villeroy
Mon Jul 30, 2018 8:17 am
- How to edit my ODB file
-
- Count lowest number in a range
by StormWolf » Sun Jul 08, 2018 1:00 pm - 4 Replies
- 910 Views
- Last post by chrisb
Fri Jul 27, 2018 8:57 pm
- Count lowest number in a range
-
- [Solved] Use query Result in the next row
1, 2 by det » Sun Jun 17, 2018 1:11 am
- 49 Replies
- 5503 Views
- Last post by eremmel
Fri Jul 20, 2018 9:23 pm
- [Solved] Use query Result in the next row
-
- [SOLVED] How Do I Make A Summary Query On One Field?
by wagtunes » Mon Jul 09, 2018 9:30 pm - 6 Replies
- 895 Views
- Last post by wagtunes
Tue Jul 10, 2018 1:41 am
- [SOLVED] How Do I Make A Summary Query On One Field?
-
- [Solved] Row_Number()
by silvrwood » Mon Jul 02, 2018 5:44 am - 5 Replies
- 969 Views
- Last post by eremmel
Mon Jul 02, 2018 4:47 pm
- [Solved] Row_Number()
Who is online
Users browsing this forum: No registered users and 1 guest
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
|