Recent content by Gman

The database I provided was a small portion of my large database. I only included the required table ans queires. The roomcalculations-2 query in my database refers to Query Roomcalculations-1, I dumped the outout of this query into a table so I could post. The calcuated feild in...

I have not solved the problem yet, I was mentioning that when I refered to a feild in the table that was in the underlying table, it worked, the lookup value was a different value for each record, and the subquery returned the correct value. But for it to work, it needs to refer to a...

If I use this code in the parent query, and change the lookup value from [Actual_Peak_Design_Sup_CFM] to a none calcuated feild in the query, it works fine. cfm: (SELECT min([valves_Lab].[M_vav_min_con_cfm]) FROM [VALVES_LAB] WHERE [Valves_Lab].[m_vav_max_cfm] > [Cooling CFM] )

I have many more tables, queries and forms and reports in my actucal databse, I just exported the tables and queries that I am trying work on as this time. files is much to large to attach. The table roomcalcs does not have a field called [Actual_Peak_Design_Sup_CFM], this is a field in the...

I have attached my database file, If you can look at, It would great

Not sure, i was copying code, so I may have mistakes, so let me recap, I have parent query where I want to put subquery SQL in a field to lookup value in another query called "Vavles_Lab" Parent Query = Roomcalculations-2 The value in the parent query is calcuated and is called...

I tired that, but when I run the parent query ( which is where i put the code) it still prompts me for the [RoomCalcualtions-2].[Actual_Peak_Design_Sup_CFM. This is a calcualted value in the parent query. I switched this to another field in the parent query which is not calculated (testing)...

OK, Trying to work out the subquery, In the Query (called "Roomcalculations-2") I have calculate a value based on other feilds in this query. I can have 1 to 1000 records. This calcuated value can be different for each record. this calculated value filed name is [Actual_Peak_Design_Sup_CFM]...

Thanks for both of your explanations, I will start testing this to se how it works, I know VBA and the basic queries, forms reports, But when I get to recordsets and subqueries, I need to research and test. I will try these methods out and let you know how it goes, Thanks for your help

I still have trouble understanding recordsets and where I should put this code. I can grasp creating a recordset that would stay open while my query runs, so that I only creat in once, instead of one for every record in the query. I just do not understand where I would put this code, does it...

I have created a function, I call the function in the query. This is the code I have, it works and finds the correct value, but did not seem to improve the speed over the Dlookup with indexed feild. Should I have down this differently, or is this the fastest that this code will run. Function...

Thanks, I indexed the column, and it did improve the speed. I am going to review the code you provided, Thanks

The values I have can vary, there is no pattern between them, I do have the table sorted by Max Row, I am using other names, I just posted those for simplicity. Min Max Setpoint Row 1 0 180 50 Row 2 181 350 75 Row 3 351 700...

I currently have a qeury that calculates a value, this value can be anywhere from 0 - 3000, I then need to use this value and lookup in a range in a table. This table has three columns, (Min, Max, Setpoint) I currently use DLookup("Setpoint", "TableNamee", "Max > Calculatedvalue")) I use...

I have heard back from anyone regarding the above questions. Does anyone have any insight on the how to accomplish this task. Thanks