Search results

  1. K

    Can't change field name in table

    I am trying to change the name of a field in a table. When I hit save, it gives me the error: "Could not find field 'originalFieldName'" I hit OK and it says: "Errors were encountered during the save operation. Properties were not updated." There are no queries, forms, reports, or...
  2. K

    Round query values up to nearest table value

    Hi, I have a table of standard Circuit Breaker (CB) sizes. I then calculate a minimum CB size in a query field. I want to use that calculated minimum value to look up the next largest CB size from the table and fill a field in the query with it. Any suggestions? For now, I am going to add a...
  3. K

    looking up table values based on two inputs

    I am creating a database to perform some engineering calculations based on user inputs and print various reports based on those calculations. My main problem is that I have tables from the National Electrical Code (NEC) that I need to pull values from. So for instance, the user will put data...
  4. K

    Converting Excel table for lookup of values based on row and column headers

    Hi, I am still trying to understand how data is best structured in Access. I have a table of values (for instance: weight) and I need to be able to look up a weight based on the column header (age) and row header (height). How is this sort of data best structured and accessed in Access? Thanks.
  5. K

    Greetings!

    Hi All, I am a new Access user with introductory knowledge of this database program. I am in Alaska, in the United States. I am building my first real database as I type this. Best, Ken
Back
Top Bottom