By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,688 Members | 1,888 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,688 IT Pros & Developers. It's quick & easy.

Update Query: Getting a Count From a Related Table???

P: n/a
Hello,

I'm trying to update the value of a field which is equal to the count
of the number of related records in a related table. So far, my SQL
statement looks like this:

UPDATE PullBoxes INNER JOIN tblConduitData ON PullBoxes.EntityId =
tblConduitData.EntityID SET PullBoxes.Conduit_Count =
Count([tblConduitData]![EntityID]);

Any thoughts would be appreciated.

-John N.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.