Hi,

I'm trying to get a field to add the total sales (money count) for the last 7 days from another database, eventually I would like to the same per month. Has anyone done this?

Your best bet is to look into subsummary parts and summary fields. This is the most flexible and standard method for reporting since you can change the report outcome simply by changing the found set.

Yes I agreed, but I would need to have the result in one field.

Here's more explanation, maybe that will help I have 3 database, 1 for store, 1 for product, 1 for sales. Now the product are sold across a bunch of store for different sales price. I would like to be able to see in 1 layout, Total sale, Sales per week, Sales per month and see all of those thing per store also.

I would prefer to have the result in a field automaticly and not run a report every time I want to see the result.

Now is that even possible, I've been scratching my brain all week, tired of having my finger up my nose (joke).