By runing the query the result of one column taking as long string.
If it is taking like that i am getting problum to fetch the data in the frontend.
Can any one help me. I am new to Access. I tried but not getting.
Thanks in advance.
Thank you for your reply.
But usually i am using sqlbase. Now i have to convert my application to acces as backend. In sqlbase when i run the query i will get the result side by side if i give coma.
But when i run in Access i am getting correct data but few columns are taking as long string so few columns data coming down. If it so i will get problum to retreve data through front end.
I mean if i used any function like LEFT, RIGHT...
This problum i am getting. Few columns data coming down.
I need to display data in row, now few columns data coming down.
I hope i am not disturbing you.
I hope you understood my problum.
Can you help me please.