Jump to content

Calcs over relation


dnowlan

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

Recommended Posts

I have received help on this but still no go. I will try better to explain the issue:

I have 2 databases:

Database 1 has a summary page to pull data from the database 1 and other related databases. Database 2 has temp employee data

I want to be able to show, in the summary page in database 1, the total dollars spent on the current found project from the temp database.

In database 2 I calculate the "record total" in database 2 and basically need to have a field in database 1 that says something like: case(project=databse2::project, sum(linetotal))

When I do this the field is blank.

Help!!

Thanks!!

Link to comment
Share on other sites

Lose the case statement. Relate the files by project number and use the sum function:

TotalFromDB2 (calculation, number) =

Sum(DB2byProjectNum::linetotal)

I'm assuming that each record in DB 1 represents a project (as you wanted to test on it using case).

-bd

Link to comment
Share on other sites

This topic is 8131 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
×
×
  • Create New...

Important Information

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