compair two tables and call a value

S

supercool

Hello Friends,
i am new to this forum i have a problem,
i have 2 tables table1 and table 2

table1 is like this and already having records as shown below
[age][term][value]
15 11 32.6
15 12 31.6
16 11 25.3
16 12 22.5
17 11 26.3

and other table2 is same with fields [age1][term1][value1] with no
records in it i want to do that if i entering value in table2 age and
term i want value
automatically in that field i;e; if [age]=[age1]&[term]=[term1] then i want
automatic display of [valu]=[value1] means if i am entering [age1]=15 and
[term1]=11 i want automatic
display and store of 32.6 in [value1] automatically. and i want to display
same procedure in form also.. plz help me for this problem :confused:​
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compair two tables and call a value 3
Joining or Combining two tables 3
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Data selection from one worksheet into a second worksheet. 1
entering query results into a variable in VBA 1
Help!! find two number recurring numbers in row?? 1
Make Y-axis values correspond to x- axis value 1
Find value based on two lookup values 2

Top