Jump to content

Imnporting multiple excel spreadsheets


Geoff Lewis
 Share

This topic is 6494 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello all from a newbie,

I am attempting to construct a database from multiple excel spreadsheets. Each sheet contains titles of electronic journals with the usage statistics each journal has had per month. Because of the way users access e-journals I have usage stats for the same title but through different portals. I have discovered how to match by journal title when importing from the different sheets, but I want to add each total onto the same title. I can match by title but cannot figure how to add each seperate figure together for the complete usage total.

Does anyone have an idea how to do this?

Any help would be much appreciated!

FileMaker Version: 6

Platform: Windows XP

Link to comment
Share on other sites

Geoff,

Not sure I understand you correctly. Are each of the different titles in seperate files/tables or are you importing them all into one file? If you can describe your structure more it will be easier to answer.

For the moment, and if it helps, you can sum fields from different files/tables, just include the relationship name eg

Sum(Relationship1::field x, Relationship2::field y, ....etc)

Link to comment
Share on other sites

This topic is 6494 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.