Search results

Thank you for everything Paul, what is the purpose of the &? Whoa....i started really analysing every little thing and i was way off here is what io have so far... =DLookUp("[GPH]","Emmiter Matrix","[FormEmmiterID]= '" & [Emmiter Matrix]![Emitter] & "' " And "[PSI Final]= " & [Emmiter...

I got something with this formula =DLookUp("[GPH]","Emmiter Matrix","[FormEmmiterID]= &[Emmiter Matrix]![Emitter]&" And "[PSI Final= & [Emmiter Matrix]![Pressure] &") But sadly it only gives me the first value of GPH in my Emmiter matrix table..so its going to the correct table and bringing...

i changd it to =DLookUp("[GPH]","Emmiter Matrix","[FormEmmiterID] = &[Emmiter Matrix]![Emitter]&" AND "[PSI Final= '"&[Emmiter Matrix]![Pressure]&"'") Still not working

Hello, I have a form which has two boxes that i want to use to go back to another table where i created a matrix with values. My form has a box that asks for an Emmiter type[FormEmmiterID] and another one that asks for a Pressure[PSI Final]... then one of my tables has the value when...

I have a form in which i inserted a Combo Box to make it easier for me to Filter my search, but on Access 2007 there is also a "search Box" at the bottom of the screen. Well, if i type something at the search box, it cannot "connect" to the combo box and my values dont update. Does anyone have a...

Hello, I have a form in which i inserted a Combo Box to make it easier for me to Filter my search, but on Access 2007 there is also a "search Box" at the bottom of the screen. Well, if i type something at the search box, it cannot "connect" to the combo box and my values dont update. Does...

I had struggled so much trying to get that to work, thank you so much...what does the NZ do? or what does it stand for?

Ok I did not get it how i wanted but i found a solution. I created a query just with my ranch stuff, where it asked what ranch i wanted.. then based on that I created another query where i included the area. that way, it would ask me for a ranch, then asked for an area, returning all...

Thank you both for your responses, but im still having trouble.. just.a.guy, what you posted gave me a really good idea of what i need to do but my problem wasnt my ID, it was my area being "N,S" north or south. In some cases we have a ranche with 2 locations N,S, (004 N, and 004 S)and...

I have a table like this Ranch, Area, ID, Acres , Trees, ect.... 01 001-01, 30 , 900 , 01 001-02, 15 , 500 , 02 ,N , 002-01, 20 , 20 , 02 ,S ,002-02, 15 ,100 . Thats a small sample of my table, But for some...