how to update many-to-one

J

John

I have two tables with a one-to-many relationship, and i need to SUM all the
records of one field that link to each 'one' side for each record on the
'one' side. I can do this with a select query, but then I keep getting errors
in an update query I built to transfer that select query into the 'one'
table. errors such as 'key violation' and 'must have at least one destination
field'. please help, thanks.
 
K

Klatuu

Did your really mean to say:
I have two tables with a one-to-many relationship, and i need to SUM all the
records of one field that link to each 'one' side for each record on the
'MANY' side.
Click to expand...

If so, put you hands in the air and back away from the computer! :)

It is never a good database design to carry calculated valued in a table. It
is better to do the calculation at the time you need it. Calculated fields
can easily become incorrect. It is also a waste of disk space and time.
 

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

Adding data to MS Access from csv file 0
SUM in a UNION query 2
multiple one to many 2
key violation 2
QBF & Query Malfunction 0
Seriously, I need ideas. Fields not transferring from table to table 5
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Left join in query 14

Top