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
- 26473 Views
- Last post by RoryOF
Sat Sep 21, 2019 10:47 pm
- Apache OpenOffice 4.1.7 released
-
- Topics
- Replies
- Views
- Last post
-
- Create query to show clients from specified city
by RosarioCarrillo » Thu Dec 05, 2019 8:07 am - 11 Replies
- 125 Views
- Last post by RosarioCarrillo
Thu Dec 05, 2019 5:36 pm
- 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
- 173 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
- 5022 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
- 286 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
- 119 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
- 199 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
- 446 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
- 456 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
- 264 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
- 317 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
- 554 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
- 203 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
- 1500 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
- 317 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
- 517 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
- 357 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
- 331 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
- 651 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
- 273 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
- 712 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
- 371 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
- 331 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
- 602 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
- 515 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
- 534 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
- 331 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
- 257 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
- 423 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
- 1171 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
- 600 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
- 424 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
- 294 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
- 392 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
- 966 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
- 408 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
- 8106 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
- 535 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
- 1566 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
- 352 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
- 409 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
- 887 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
- 913 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
- 416 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
- 1440 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
- 891 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
- 435 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
- 777 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
- 1355 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
- 494 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
- 1039 Views
- Last post by Maax555
Tue Oct 23, 2018 10:38 am
- [Solved] Using Alias filed within a query
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
|