Forms Help

[lala]

Are you using Access 2007?

If so, I just do it like this.

Select the subform table, or table you are wanting the total column on, in Form view.

Then apply a 'totals' row.

the same button is in access 2003 and i think 2000 as well

it makes a query groupBy
look on the toolbar in the Design View of the query

 

[lala]

and as far as the sample database tarcona just posted, in the Sum textbox the field name should be total, not txttotal, and then it works

 

[Chrisopia]

Northwind sample

Quick look through the sample database...

the form is made from a cross tab query,

Quarters: "Qtr " & DatePart("q",[OrderDate],1,0)

Group by
crosstab: column heading

What is DatePart "q"?

what is the DatePart function?

Obviously I need to customise this for my needs, and I'm summing up by order number, not date...


I'll report back when I've had a play around my database.

 

[lala]

all you have to do, in tarcona's sample (in his posting he has your database attached) in the sum box change TXTTOTAL to TOTAL, and then it works and you get the total

 

[tarcona]

Solved it. Lala was right. See the attachment:

 

[Chrisopia]

Yey it worked,

thanks team!!