Search results

  1. 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...
  2. 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...
Back
Top Bottom