Jump to content

Summing Fields


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

Recommended Posts

I have a database that sums spending by brand.

The database holds spending for an entire year and I want the user to be able to choose a date range to pull desired spending.

I want to bring that sum into another database (I want to use a field to bring it in).

I am having trouble getting that number into the desired database.

I only want the sum of those records that are in the found set not the sum for the total records.

When I use a calc field referencing the SUM field it brings in the total spend not the spend for the found set.

Any thoughts on how to make this work?

Thanks for any help...

Link to comment
Share on other sites

This topic is 6454 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.