The file is not open and the Autosys ID has admin rights.

Thanks

Sam.

Thanks for the reply. I tried but there is no SIGN function in Access and its giving empty resultset. Please advise.

San.

Any help would be greatly appreciated. Thanks in advance.

San.

It takes little time to migrate to Sql Server and in the mean time I need this in Access.

Thanks

San.

Thanks peter. How to accomplish the same in Access. Really appreciate your help.

San.

Thanks. We are also running these reports in access till we fully migrate to Sql Server. So should work both in Access as well as Sql Server. Any help would...

Thanks for the reply. My data looks something like below.

Thanks for the reply. But my goal is.......

When the user selects Drinks, it should display the data in the following way.

0   DRINKS   BEVERAGES

     2 HOT DRINKS

         7 TEA

         7 COFFEE

        ...

try using this.......

Dim lsTemp as String

lsTemp ="NULL"

or lsTemp = vbNull

Thanks Prakash.

The example in the link shows recursive method using a single table. But in my case the data is present in two tables. Ex.GROUP and PRODUCT.

Any suggestions how to...

Please provide the link. Thanks.

Any help would be greatly appreciated. Thanks.

Please help. Thanks

Any suggestions. Thanks in advance.

Please.......any suggestions to accomplish this. Thanks in advance.