Search results

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...

Alright, I think I am understanding how to use a query better now. I thought I should put all the fields I want to use in my calculations in the query, but for the most part I shouldn't put fields used in calculations in the query. Query fields should be calculated from fields outside the query...

I'm going to try moving to using Join's in SQL, but I haven't done anything in SQL yet, so first I want to try to get it to work with my options in Design View. I created a second query "MotorQ2" which receives the information calculated in the first query "MotorQ" and calculates one more...

And I realize now that if I change to SQL view I have: SELECT MotorT.ID, MotorT.[Motor Name], MotorT.Voltage, MotorT.Phase, MotorT.[Nameplate Current], MotorT.CircuitLength, MotorT.Horsepower, MotorT.RacewayMaterial, DLookUp("[Current]","[NEC430_250IndT]","[NEC430_250IndT].[HP]=" &...

In design view.

I haven't been using SQL, that is what I put in the "Field:" box for the field I am making in the MotorQ query.

Thanks, that look like it should work well. When I try to implement that, in the MotorQ query, I am using the code: Standard Breaker Size: DMin("[SC Rating]","[BreakerT]","[BreakerT].[SC Rating]>"& [MotorQ].[SC Rating]) but it keeps asking me to input the parameter value: MotorQ.SC Rating...

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...

Welcome! You should be able to find some good help.

Thank you, I got Dlookup to work.

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...

Galaxiom: Using three fields so that I can retrieve on the Age and Height fields and return a Weight makes a lot of sense theoretically. What do you mean by joining to the other data? Is there a way to do this with relationships so that when I fill in an age and height it automatically pulls...

I can put the three fields: age, height and weight in the query, but those represent a standard table of data which can be referenced. I have a form to input the age and height, the table is information that is built into the database. How do I get the specific weight from the table for a...

I am using the weight values one at a time to calculate other values in the query and output all of it to a report.

Back to my initial problem: I am creating a query which needs to pull a specific weight from the table based on the age and height. I am trying to do this with the dlookup function. Is there a simpler way to pull this value of weight? Galaxiom referenced doing this as if it was a built in...

Alright, putting three fields in one table makes sense. It just seems like I end up repeating a lot of data in the table since there are age X height number of weights and repeated data is what Access is supposed to be good at getting rid of. But since there is no other data linked to each...

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.

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