Max Function in a query.

G

Guest

Hi,
I have two tables( Table_1 and Table_2) and Table_2 has a field that
calculate the max value from one field in Table_1.
I have the macro to calculate the max value, but I could not save this value
in Table_1.

Table_1
Field_1 Field_2 Field_3
X 10 20
y 11 21
z 12 22

The results of the query should update Table_2 as shown:
Table_2
Field_1 Field_2
12 22

Any help please,
 

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

Update table from another table. 2
Creating a Primary Key from Other fields 6
6 Tables, one form. I give up. 3
update query 2
Display table and field names in query results 6
IF Function Format -- Microsoft Query 2
Calculated field using IF statements in the Query Grid 2
Calculated field using Query Grid and IF statement 9

Top