Report!!!!!

[keyur1719]

Hi,

In reoprts when we put a bonded control (say a Text Box) in the Detail section, it gets auto generated based on the number of record in the record source property of the report.

Is there any way we can stop this auto generation of controls in the Detail section.

Soonest reply will be highly appreciated

Thanks

Keyur

[missinglinq]

I'm not really sure what you're asking! When you place a bound (not bonded) control on a report or form, it's going to generate one for each record in the underlying record set. There's no way to prevent this, nor should there be! Maybe if you re-word your question we'll be able to provide you with the help you reuire.

Welcome to TheScripts!

Linq ;0)>

[keyur1719]

I'm not really sure what you're asking! When you place a bound (not bonded) control on a report or form, it's going to generate one for each record in the underlying record set. There's no way to prevent this, nor should there be! Maybe if you re-word your question we'll be able to provide you with the help you reuire.

Welcome to TheScripts!

Linq ;0)>

Hi,

here is what i am looking for.

I am creating a dynamic report using VBA code based on a query. The query has following type of data

EmpName EmpTeam Month Amount
xxxxx yyyyy November 500.00
aaaaa bbbbb November 250.00
xxxxx yyyyy December 1000.00
aaaaa bbbbb December 750.00

I want to show output of above query in below given format, through VBA code.

EmpName EmpTeam November December
xxxxx yyyyy 500.00 1000.00
aaaaa bbbbb 250.00 500.00

I want this output without using the crosstab query. Is it possible to do this through VBA Code?

Thanks

Keyur