open table with multiple records of primary key, sum one field so

F

florida fumbler

Need help writing a module to open table with multiple records of primary
key, sum one field so total can be written to flat file table. FYI. I am
trying to build a system to combine several different county property tax
rolls, in different formats to search for comparable sales and available land
parcels. One of the counties has a master file with parcel numbers, and a
second table with multiple records for various parcels comprising the whole,
with acreage for eachg piece. I need to sume total of acreage for pieces and
write it back to master file as a total. Have not worked with VBA that much
and am really fumbling. Most referenced talk about declaring database
variables, but none seem to work. Help
 

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

Insert records into a table with a primary key 0
add one field, multiple records 1
Tab Key on Primary form with Subform 2
Picking specific records from a table 1
Find Duplicates in one column and sum other column 1
Limit sum() by one year and primary key? 1
Counting the sum of related records for a primary record 4
Update and append records in one table based on shared primary key 4

Top