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