how to insert the value from the query into existing table field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

now, i have one query contains
captivate_name, totalmarks, name, totalmarks2.
is it possible to pass the value from query which are totalmarks and
totalmarks2 into table test that contains fields which are totalmark and
totalmarks2? if it was possible, can you help me on how to do that..
 
now, i have one query contains
captivate_name, totalmarks, name, totalmarks2.
is it possible to pass the value from query which are totalmarks and
totalmarks2 into table test that contains fields which are totalmark and
totalmarks2? if it was possible, can you help me on how to do that..
Click to expand...

Well, it's possible, but generally one would NOT want to do so. The
names of the fields "totalmarks" suggest that these are calculated
totals... right? If so, it's almost always best just to recalculate
the value based on the data stored in the table. You can base a Form,
Report, export, or pretty much anything on a Query; there's no need to
store the information redudnantly.

Perhaps you could explain what this query is, and why you're trying to
store this information, apparently redundantly?

John W. Vinson[MVP]
 
Back
Top