Search results
-
R
Query all records and sum only records from this year.
Works perfectly. The "Year" heading was just for the example. I knew better than that. I'll change the other column heading too. Thanks. -
R
Query all records and sum only records from this year.
Sorry about awkward wording. I want the new query to return $0.00 if and expense in that category has not occurred YTD. So the query I am taking data from looks something like: And the query I would like to make would look something like this I hope that makes it more clear. -
R
Query all records and sum only records from this year.
I have created a query from two tables with the following SQL statement I would like to query that query to return every category and sum amount values that occur Year-to-date, and there is no transaction year-to-date, it returns a $0.00 for the amount. I think I need the Nz function, but I'm... -
R
Open form based on table values
I'm sure I can't be the first to need this, but I have yet to find it. I have a table with the fields Thermometer_ID (primary key) and CalibrationType (combo box list with the options of InHouse or SendOut) I want the user to click on a button and have an input box to input the...