REPORTS IN VB ^>)

[phoncy]

I have an access table with fileds like

Name Units ftse
alphonce scs100 0.111
alphonce scs 110 0.123

grace scs100 0.145
grace scs 110 0.145


I want a vb report with the following results from this table

Name units ftse TOTALFTSE
alphonce scs100 0.111
alphonce scs 110 0.123
0.234


grace scs100 0.145
grace scs 110 0.145
0.290
please help

[hariharanmca]

I have an access table with fileds like

Name Units ftse
alphonce scs100 0.111
alphonce scs 110 0.123

grace scs100 0.145
grace scs 110 0.145


I want a vb report with the following results from this table

Name units ftse TOTALFTSE
alphonce scs100 0.111
alphonce scs 110 0.123
0.234


grace scs100 0.145
grace scs 110 0.145
0.290
please help

I think you lock your shift for 6.0 okay but you never mension which report that you are using?

[phoncy]

I think you lock your shift for 6.0 okay but you never mension which report that you are using?

Am using vb 6.0 report,i.e the one from data member and data report

[hariharanmca]

Am using vb 6.0 report,i.e the one from data member and data report

add two command and
1. desigen a view in database for your record selection.
2. desigen another view in database for sum of value for the selected record and
3. connect this two viewes to the command button
4. place the second command button's sum value in report footer.