Probleum in printing the value

[progvar]

Hi!
i have a query and i want to print the value of this query by programing. I use this query in ms-access and works fine but when i execute this query in visual basic it does't produce any error but no value is printed. Please provide the help

Set dbMn = Workspaces(0).O penDatabase(txt path)

Set RSmn = dbMn.OpenRecord set("SELECT UDAC, count(*) AS RCOUNT

from " & txttable & " GROUP BY UDAC ORDER BY UDAC")

txtpth = "D:\back_fastli nk221\demo softwares\DEMO\ REPORT.XLS"

Open txtpth For Output As #1

Print #1, UDAC, RCOUNT

[mafaisal]

Hello
Try This

Print #1, RSmn!UDAC ;tab(10);RSmn! RCOUNT

Here u Forgot use of recordset

Faisal

Hi!
i have a query and i want to print the value of this query by programing. I use this query in ms-access and works fine but when i execute this query in visual basic it does't produce any error but no value is printed. Please provide the help

Set dbMn = Workspaces(0).O penDatabase(txt path)

Set RSmn = dbMn.OpenRecord set("SELECT UDAC, count(*) AS RCOUNT

from " & txttable & " GROUP BY UDAC ORDER BY UDAC")

txtpth = "D:\back_fastli nk221\demo softwares\DEMO\ REPORT.XLS"

Open txtpth For Output As #1

Print #1, UDAC, RCOUNT

[progvar]

Hi!
THANKS IT WORKS


VARINDER

Hello
Try This

Print #1, RSmn!UDAC ;tab(10);RSmn! RCOUNT

Here u Forgot use of recordset

Faisal