Consolidating fields in Acces

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

Guest

I have imported data from an excel spreadsheet into Access. In one field
there are multiple occurances of the same entry-eg "cottonwood estates" the
field next to that contains date for this entry. I am trying to have all the
date for "cottonwood estates" to be added together and be on one line in a
report or pivot table or table. Is this possible?
 
You can import the Excel data into what will be a "temporary" table. Then
create queries to parse the data into more permanent, well-normalized
tables.

By the way, how you display data in a report has very little to do with good
approaches to storing data in relational database tables...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

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

Access Access - Is it possible to repeat fields in a form? 1
Access Daily Entry with multiple entries per field 0
Data consolidation 1
Validation rule build on other field in the same table 5
Consolidate Pivot Tables/Cache using Excel 2003 1
Consolidate records from one table into another? 5
Calculations Across Multiple Records 13
Reports/SubReports 2

Back
Top