Otis
Elite Member
- Joined
- Apr 22, 2015
- Messages
- 4,592
Hey there. I'm trying to use database software to help automate some budget tasks. My previous experience with database software was in the 1980s, when I developed programs using an MSDOS version of dBASE. However, database freeware these days all seem to be menu driven, and the newer vocabulary is not always clear to me.
Is anyone in the forum familiar with OpenOffice Base? It's the open-source database in Apache's software suite (developed as an alternative to Microsoft Office.)
I'm not understanding some results, after trying to follow online help. Here's my first situation.
I've created a simple database (named HCS) for expenses; each record contains four fields {ID, DATE, TYPE, AMT}.
I would like to sum the AMT field for records in 2022. I need help understanding how to set conditions on the date field when I make the query, in order to restrict the summation to 2022 dates. (I'm using the built-in wizard to create the query.)
Here's the wizard's dialog box for setting the selection conditions (Step 3).
I don't understand why, but, during the first day experimenting, the Value field would immediately change to an Integer (like 44516) after entering the dates. I'd given up, for the weekend. Today, however, the date values do not change to Integers. (I can't tell whether that weirdness is relevant, but it's weird, nonetheless.)
Here's the dialog box for the summation instruction (Step 4).
This is the overview (Step 8).
As you can see, the claim is that no conditions were set. When I click finish, the query runs and simply displays the AMT value from each record.
I took 10 screenshots, during my attempt to use the wizard. I've posted only what seems relevant. I'd skipped Steps 5,6,7 because I'm not listing the records or displaying field names; I just want the sum. (When I query the sum of all records, it works fine.)
I won't be surprised if I've made an obvious mistake. Regardless, I hope to be schooled. ?
Is anyone in the forum familiar with OpenOffice Base? It's the open-source database in Apache's software suite (developed as an alternative to Microsoft Office.)
I'm not understanding some results, after trying to follow online help. Here's my first situation.
I've created a simple database (named HCS) for expenses; each record contains four fields {ID, DATE, TYPE, AMT}.
I would like to sum the AMT field for records in 2022. I need help understanding how to set conditions on the date field when I make the query, in order to restrict the summation to 2022 dates. (I'm using the built-in wizard to create the query.)
Here's the wizard's dialog box for setting the selection conditions (Step 3).
I don't understand why, but, during the first day experimenting, the Value field would immediately change to an Integer (like 44516) after entering the dates. I'd given up, for the weekend. Today, however, the date values do not change to Integers. (I can't tell whether that weirdness is relevant, but it's weird, nonetheless.)
Here's the dialog box for the summation instruction (Step 4).
This is the overview (Step 8).
As you can see, the claim is that no conditions were set. When I click finish, the query runs and simply displays the AMT value from each record.
I took 10 screenshots, during my attempt to use the wizard. I've posted only what seems relevant. I'd skipped Steps 5,6,7 because I'm not listing the records or displaying field names; I just want the sum. (When I query the sum of all records, it works fine.)
I won't be surprised if I've made an obvious mistake. Regardless, I hope to be schooled. ?