Can this be dun?

[jdraw]

I looked at your database. There are several queries with similar names?? There are many tables without relationships??
I still don't know what you are trying to do.

I suggest you give us a specific example in plain English to follow - Telling us what is input, any parameter values, and what you expect a the result.

 

[Sm0ke]

I cleaned up the queries, I do not know what you mean about the relationships. Here is what I am trying to do, Have a Table “Brown Wire CT” we list all of the teat wire in the Brown Wire CT Query it auto calculate the correction factor and I wont to do the same thing with Table “K Type Fluke” but add the date of test and when it is due, and I have done that. What I need help with is pull the correction factor from “Brown Wire CT” and “K Type Fluke” in to “FreezerSAT1Query” base on test date and what Fluke and brown wire was used.

 

[arnelgp]

Pay close attention at expr1, expr2 and expr3. Also at midule1 where i call a func for expr1.

 

[Sm0ke]

Thank You arnelgp that is what I needed

 

[arnelgp]

Youre welcome.

 

[Sm0ke]

I would like to thank you again for your help. Another problem can up and I hope you can help again, I made the form but it will not let me update or add to it. I know that I did not do something. To make this simple I zip and attach the Database.