Need help with syntax

[Guest]

IF TblAgentNames.SecurityLvl > 1
WHERE TblAgentNames.WindowsSignOn = FctWindowsName
THEN do something

FctWindowsName returns the windows log on name. I want to compare the
security level of the logged on user and then take some action. Any help will
be appreciatted! Cheers!

 

[Alex Dybenko]

Try:

If nz(dfirst("SecurityLvl","TblAgentNames","WindowsSignOn = '" &
FctWindowsName & "'"),0) >1 then
....
end if

note that FctWindowsName should be in single quotes in resulting condition
argument

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Thank you Alex, I'll give it a try as soon as I can. Appreciatte it!