Creating tables and queries
-
- [Solved] Count query with junction tables, conditions, sort
by Doranwen » Fri Jan 15, 2021 9:08 am
- 7 Replies
- 161 Views
- Last post by Doranwen
Sat Jan 16, 2021 12:16 am
-
- [Solved] Query with user input and code formatting
by BrianME » Tue Jan 05, 2021 9:53 pm
- 5 Replies
- 285 Views
- Last post by Villeroy
Thu Jan 07, 2021 9:37 pm
-
- [Solved] CASE statement returning nulls
by superfuntastic » Sat Jan 02, 2021 4:48 am
- 3 Replies
- 239 Views
- Last post by dreamquartz
Wed Jan 06, 2021 5:49 pm
-
- Auto Filling fields from a different table
by NevP » Tue Dec 15, 2020 1:33 am
- 4 Replies
- 373 Views
- Last post by NevP
Wed Dec 16, 2020 1:26 am
-
- Auto-Increment jumped by >2000
by the ber » Mon Dec 14, 2020 6:26 pm
- 4 Replies
- 203 Views
- Last post by Villeroy
Tue Dec 15, 2020 11:58 am
-
- [Solved] Aggregate of subquery
by StormWolf » Sun Dec 06, 2020 11:59 pm
- 1 Replies
- 239 Views
- Last post by StormWolf
Mon Dec 07, 2020 12:35 am
-
- [Solved] Subtraction in a query
by StormWolf » Sun Dec 06, 2020 2:08 am
- 4 Replies
- 236 Views
- Last post by StormWolf
Sun Dec 06, 2020 9:07 am
-
- Create query with macro
by kevinT220 » Thu Nov 26, 2020 5:58 am
- 3 Replies
- 322 Views
- Last post by UnklDonald418
Thu Nov 26, 2020 7:06 pm
-
- Problem in direct data entry
by megha bhavsar » Mon Nov 23, 2020 11:47 am
- 1 Replies
- 109 Views
- Last post by UnklDonald418
Mon Nov 23, 2020 6:48 pm
-
- [Solved] Relationship design - one-to-one or giant table?
by Doranwen » Fri Nov 06, 2020 9:35 pm
- 19 Replies
- 852 Views
- Last post by Doranwen
Sun Nov 08, 2020 9:14 pm
-
- [Solved] Add a numbered field
by GauSte » Tue Oct 20, 2020 11:43 pm
- 7 Replies
- 754 Views
- Last post by Villeroy
Sat Oct 24, 2020 1:52 pm
-
- [Solved] String/Date Conversion (HSQL25.)
by gkick » Thu Oct 01, 2020 3:58 am
- 3 Replies
- 666 Views
- Last post by Villeroy
Thu Oct 01, 2020 7:42 am
-
- Using same report for updated database
by knight2 » Sun Sep 27, 2020 9:35 pm
- 4 Replies
- 483 Views
- Last post by Villeroy
Mon Sep 28, 2020 6:48 pm
-
- [Solved] Problem in direct data entry
by meeranair2020 » Tue Sep 08, 2020 5:28 pm
- 3 Replies
- 719 Views
- Last post by UnklDonald418
Tue Sep 15, 2020 5:49 pm
-
- [Solved] Setting a multifield constraint
by gkick » Sat Sep 05, 2020 6:46 pm
- 2 Replies
- 395 Views
- Last post by gkick
Sat Sep 05, 2020 9:34 pm
-
- [Solved] Average within dynamic daterange
by gkick » Sat Aug 22, 2020 2:28 pm
- 3 Replies
- 672 Views
- Last post by gkick
Sat Aug 22, 2020 4:19 pm
-
- [Solved] IF/THEN in a query criteria
by asiegelson » Mon Aug 17, 2020 5:00 pm
- 4 Replies
- 624 Views
- Last post by asiegelson
Mon Aug 17, 2020 10:13 pm
-
- Error inserting a new record (Null)
by Kzneft » Sun Aug 16, 2020 10:04 pm
- 4 Replies
- 562 Views
- Last post by UnklDonald418
Mon Aug 17, 2020 6:57 pm
-
- [Solved] Different behavior of IS NULL with LO and OO
by charlie.it » Thu Jul 02, 2020 4:28 pm
- 14 Replies
- 2357 Views
- Last post by charlie.it
Sun Jul 05, 2020 9:16 am
-
- [Solved] Help with temporary table (HSQL2.5)
by gkick » Thu Jun 04, 2020 10:17 pm
- 15 Replies
- 2225 Views
- Last post by Sliderule
Sun Jun 07, 2020 11:42 pm
-
- [SOLVED] Need Query to limt by last sale price of each item
by widowmaker » Fri May 22, 2020 6:15 pm
- 8 Replies
- 1570 Views
- Last post by widowmaker
Fri May 29, 2020 3:04 pm
-
- Mutually Exclusive Check Boxes
by Mickey12 » Fri May 29, 2020 11:41 am
- 2 Replies
- 504 Views
- Last post by robleyd
Fri May 29, 2020 12:30 pm
-
- [Solved] Crosstab Query Help with Error
by gkick » Sun May 24, 2020 5:01 am
- 3 Replies
- 719 Views
- Last post by gkick
Mon May 25, 2020 12:09 am
-
- [Solved] Help preventing deletion in a table or form via Tri
by gkick » Sat May 23, 2020 8:37 am
- 3 Replies
- 688 Views
- Last post by gkick
Sat May 23, 2020 5:34 pm
-
- [Solved] SQL Query Comparing Strings
by JohnNorris » Thu May 07, 2020 1:47 am
- 6 Replies
- 1085 Views
- Last post by robleyd
Fri May 08, 2020 8:06 am
-
- [Solved] Filtertable containing concatenated field
by gkick » Mon Apr 20, 2020 1:44 am
- 0 Replies
- 564 Views
- Last post by gkick
Mon Apr 20, 2020 1:44 am
-
- [Solved] CASE WHEN or sql loop?
by gkick » Sat Mar 28, 2020 7:14 am
- 3 Replies
- 964 Views
- Last post by gkick
Sun Mar 29, 2020 9:49 pm
-
- Creating a database
by cblumtritt@aol.com » Fri Mar 27, 2020 2:18 am
- 1 Replies
- 576 Views
- Last post by robleyd
Fri Mar 27, 2020 2:50 am
-
- [Solved] Populating filter table with date functions
by gkick » Wed Mar 18, 2020 6:36 am
- 13 Replies
- 1877 Views
- Last post by gkick
Sat Mar 21, 2020 9:57 pm
-
- [Solved] Negative parameter for query problem
by cwdavi1 » Thu Feb 13, 2020 10:40 pm
- 4 Replies
- 1128 Views
- Last post by Russ Ullman
Sat Feb 15, 2020 7:35 pm
-
- [SOLVED] Cannot open table section
by brandobaris » Wed Jun 10, 2015 4:46 am
- 3 Replies
- 2031 Views
- Last post by rulerofallchickens
Sun Feb 09, 2020 7:01 pm
-
- [Solved] Find session_user in HSQL2.5
by gkick » Tue Feb 04, 2020 6:13 am
- 2 Replies
- 695 Views
- Last post by gkick
Tue Feb 04, 2020 1:21 pm
-
- Entering new data in a Query
by Ladybug1972 » Wed Jan 29, 2020 4:19 pm
- 2 Replies
- 661 Views
- Last post by Villeroy
Wed Jan 29, 2020 6:06 pm
-
- [Solved] Query inside select statement
by the ber » Mon Jan 27, 2020 12:38 pm
- 3 Replies
- 722 Views
- Last post by the ber
Tue Jan 28, 2020 9:41 am
-
- How split multiple strings in a column
by arfgh » Thu Jan 16, 2020 12:53 am
- 15 Replies
- 1810 Views
- Last post by Villeroy
Wed Jan 22, 2020 11:07 pm
-
- [Solved] Recurring query problem
by gkick » Thu Jan 16, 2020 3:14 pm
- 9 Replies
- 1063 Views
- Last post by chrisb
Fri Jan 17, 2020 2:22 pm
-
- [Solved] Primary Key not Saved
by rhammer54 » Sat Jan 04, 2020 2:40 pm
- 5 Replies
- 1021 Views
- Last post by rhammer54
Sun Jan 05, 2020 3:07 pm
-
- [Solved] Date Function ? Find specific days of week
by gkick » Mon Dec 23, 2019 8:52 pm
- 12 Replies
- 1868 Views
- Last post by Villeroy
Sun Dec 29, 2019 6:07 pm
-
- [Solved] Timestampdate to string or number
by gkick » Sat Dec 28, 2019 5:19 am
- 2 Replies
- 587 Views
- Last post by gkick
Sat Dec 28, 2019 12:19 pm
-
- [Solved] Table/number formatting/currency does not stay
by Arbe » Thu Dec 26, 2019 4:20 am
- 2 Replies
- 686 Views
- Last post by Arbe
Thu Dec 26, 2019 8:29 pm
-
- [Solved] Maths or Logical Issue
by gkick » Sun Dec 22, 2019 4:08 am
- 2 Replies
- 661 Views
- Last post by gkick
Sun Dec 22, 2019 4:59 am
-
- [Solved]Converting timestamps
by gkick » Fri Dec 20, 2019 6:18 am
- 3 Replies
- 658 Views
- Last post by gkick
Fri Dec 20, 2019 4:54 pm
-
- [Solved] Query extract size from last 2 numbers after dash
by cartoonjazz » Wed Dec 18, 2019 9:15 pm
- 4 Replies
- 810 Views
- Last post by cartoonjazz
Thu Dec 19, 2019 5:51 pm
-
- [Solved] Create query to show clients from specified city
by RosarioCarrillo » Thu Dec 05, 2019 8:07 am
- 16 Replies
- 2031 Views
- Last post by RosarioCarrillo
Fri Dec 06, 2019 9:05 am
-
- [Solved] SQL How to update current row
by gkick » Tue Nov 26, 2019 9:03 pm
- 2 Replies
- 655 Views
- Last post by gkick
Tue Nov 26, 2019 10:02 pm
-
- [Solved] Simple dumb? Can't use SaveAll...now! Export to CSV
by MSPhobe » Sun Mar 12, 2017 4:43 pm
- 10 Replies
- 6949 Views
- Last post by doubleDog55
Mon Nov 18, 2019 5:56 pm
-
- [Solved] Need Help whether to have split database
by Registry » Thu Nov 07, 2019 5:25 pm
- 4 Replies
- 1039 Views
- Last post by Registry
Sun Nov 10, 2019 1:52 pm
-
- Dropdown list in query parameter input
by MHCom » Fri Nov 08, 2019 5:00 pm
- 1 Replies
- 597 Views
- Last post by F3K Total
Fri Nov 08, 2019 5:51 pm
-
- [Solved] Additional auto increment on no pk
by gkick » Tue Nov 05, 2019 6:13 pm
- 4 Replies
- 818 Views
- Last post by gkick
Fri Nov 08, 2019 5:12 am
-
- [SOLVED]Macro/Query Failure after updating to split database
by aterbo » Tue Oct 22, 2019 10:49 pm
- 6 Replies
- 1276 Views
- Last post by Villeroy
Thu Oct 24, 2019 1:06 pm
Return to Board index
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