asked on

Sum column, split form

I have a form in split mode with the datasheet at the bottom. I thought I could sum the field [Amount] but doesnt look like I can. is there some trick to doing this?

thank you

Hamed Nasr

I can't see why not.
Upload a sample database with few records, and show how do you want the output.
Include any other info on how do you want to use it. For example, do you want to insert new records and show the total?

Helen Feddema

How are you doing the sum (DSum expression, Totals query, or ??)

pdvsa

ASKER

Sorry for my late reply.

I attached a pic of the form. I am looking to sum [FX USD Equiv] but the sum should be at the bottom on the new record line. Its a calculated field.

thank you.

pdvsa

ASKER

The form is in datasheet.

Hamed Nasr

Create a sample database showing the issue.
Show a picture of the output.
Do you want it to allow for editing?

pdvsa

ASKER

hnasr:

If you look at the picture all I need is a sum of [FX USD Equiv] but would like it at the bottom much like you would sum in excel. I know I have seen this option in other forms....you can click the new record row, under that column, and you would see a "sum" option to sum for that column. Do you know what I am talking about?

Hamed Nasr

If not resolved, just reproduce the issue and upload.

ASKER CERTIFIED SOLUTION

pdvsa

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pdvsa

ASKER

I believe I have to accept my own answer. Let me know if there are any objections. Thank you.

pdvsa

ASKER

probably did not describe my issue that well...thank you though...