Today, however, the date values do not change to Integers. 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. Here's the wizard's dialog box for setting the selection conditions (Step 3). (I'm using the built-in wizard to create the query.) 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 would like to sum the AMT field for records in 2022. I've created a simple database (named HCS) for expenses each record contains four fields. I'm not understanding some results, after trying to follow online help. 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.) However, database freeware these days all seem to be menu driven, and the newer vocabulary is not always clear to me. My previous experience with database software was in the 1980s, when I developed programs using an MSDOS version of dBASE. I'm trying to use database software to help automate some budget tasks.

Open office base database