Help on INSERT INTO SQL

[Guest]

Can someone please help me out on this and correct my SQL so it actually
works? This is what I have so far and it's not pretty:

INSERT INTO Table1 ([MinVol]) SELECT MIN([Volume]) FROM Table2
WHERE Table1.[Symbol] = Table2.[Symbol] GROUP BY Table2.[Volume];

What I want is the minimum value of VOLUME found in TABLE2 inserted into the
field "MinVol" in TABLE1 where ever Table1.[Symbol] = Table2.[Symbol].

Thanks much in advance for your assistance.

 

[Marshall Barton]

Can someone please help me out on this and correct my SQL so it actually
works? This is what I have so far and it's not pretty:

INSERT INTO Table1 ([MinVol]) SELECT MIN([Volume]) FROM Table2
WHERE Table1.[Symbol] = Table2.[Symbol] GROUP BY Table2.[Volume];

What I want is the minimum value of VOLUME found in TABLE2 inserted into the
field "MinVol" in TABLE1 where ever Table1.[Symbol] = Table2.[Symbol].

An INSERT INTO query appends records to a table. You want
to use an UPDATE query. Unfortunately, Update queries have
trouble dealing with a subquery so you will probably have to
use DMin instead of the subquery.

 

[Guest]

Use this update when Symbol is String
UPDATE Table1 SET Table1.MinVol = DMin("volume","Table2","Symbol ='" &
[Symbol] & "'")
========================================
Use this update when Symbol is Number
UPDATE Table1 SET Table1.MinVol = DMin("volume","Table2","Symbol =" &
[Symbol])
========================================

 

[Guest]

Thanks!

Use this update when Symbol is String
UPDATE Table1 SET Table1.MinVol = DMin("volume","Table2","Symbol ='" &
[Symbol] & "'")
========================================
Use this update when Symbol is Number
UPDATE Table1 SET Table1.MinVol = DMin("volume","Table2","Symbol =" &
[Symbol])
========================================

Can someone please help me out on this and correct my SQL so it actually
works? This is what I have so far and it's not pretty:

INSERT INTO Table1 ([MinVol]) SELECT MIN([Volume]) FROM Table2
WHERE Table1.[Symbol] = Table2.[Symbol] GROUP BY Table2.[Volume];

What I want is the minimum value of VOLUME found in TABLE2 inserted into the
field "MinVol" in TABLE1 where ever Table1.[Symbol] = Table2.[Symbol].

Thanks much in advance for your assistance.