setting up an "Accounts Receivable" db

[waredata]

I have my tables 1 for client personal infor, 2 post charges, 3 post payments.
I need to have a aging report base on dates, then print out a statement.

[NeoPa]

There seems to be no question here.

You should understand that we don't work on the basis of a free resource to do your work for you. We can answer specific questions and even give advice where appropriate. If you feel that can be helpful to you then I suggest you post what you had specific problems with after you started trying to implement your project.

[waredata]

@NeoPa
OK, How do i create a calc field outside of the pages where the totals are?

[NeoPa]

OK, How do i create a calc field outside of the pages where the totals are?

Frankly this is little clearer, with no context worth speaking about. Context normally allows us to guess what people are unable to express properly.

My best guess is you're asking about calculated controls in a report where the results are in a separate section from the controls (or maybe fields) they are referencing.

Firstly you should know that fields (data from the underlying record source) are not accessible to formulae in report controls. Only values from controls can be referenced. Aggregate functions (Sum(), Max(), Avg(), etc) can only be used in total sections.

More than that I cannot say without a clearer, more meaningful question.

[waredata]

I have a subform that has "Charge Amt" & "Pymt Amt" fields on the (datasheet view) form.
On the main form I need a grand total of the amounts listed on the subform (Charge Amt - Pymt Amt). Can't pick it up! Using 2007 Access..
I put = [frm detail].[Form}![Charge Amt] this will pick up one line item (there will be several chargs) I need the totals. Same goes for the Pymt Amt

[NeoPa]

That is something we can work on. We may need to ask for a little more info and maybe testing feedback, but we're on our way at least.

I'm not sure here where aggregate functions come in and what they can reference correctly without access to an example, which I don't have to hand. I know subforms can be freferenced in a number of ways. Your example will not work as posted. This may be for various reasons - The most likely of which is that you haven't copied your code across accurately. Workable ways are shown in Referring to Items on a Sub-Form. I suggest you copy and paste the actual formula you have at this time. I'd also be interested to see the actual formula for something that correctly references the controls, even though it doesn't manage to aggregate or sum them.

What we need to look at first is whether a control outside of your subform can aggregate (EG. Sum()) the values referenced in the controls found within the subform ([Charge Amt] & [Pymnt Amnt]). I suspect not, but let's get a test done to confirm before proceeding.

If it cannot, then the next thing to try would be to create a new textBox control in the subform's footer section (Ensure Form Header/Footer visible from the View Menu). This control may be hidden if preferred. The formula sums the subtraction of the two controls in the Detail section (=Sum([Charge Amt]-[Pymnt Amnt])). All this is within the subform at this stage. For the purposes of reference, we'll call this control [txtTotProfit].

This new control ([txtTotProfit]) should now be referenced directly by the control you are currently trying to set up to show the value on the main form.