Skip to Content
0
Former Member
Sep 13, 2007 at 11:37 AM

Query for Formatted Search

30 Views

Can any one help me writing a user based query ?

i want to retrieve a particular G/L account to a field.

the field must display G/L acc. corresponding to Logged in user.

for example AccCode = 100000 , when manager is logged in.

AccCode = 200000, when some other user logged in.

i tried writing a query in case of manager logged in,

but the same is reflected in case of other login also.

needed a conditional query like when manager is logged in, the field must show only the corresponding code specified for it.

plz help me...(Weak in SQL knowledge)

thks in Advance!

dhana.