Recent content by mcreary

Thanks Guys

I need help in writing a quick and dirty code that will return specific values if certain conditionsIf then else function. I have a hundred conditions. IIF Hierarchy Like "CESS*" Or "CXXA*" Or "CLKAA*" Then Return "line Of Business". If Hierarchy Like......etc Please help

I think I can help with that answer but the question is too vague. i think that a brief description of the table and quesry so i could put an example together would be a big help!

Hi, can anyone tell me how to doubleclick on field (on a form) and it opens up a form that shows bounded filtered results. I have a sub form which has details supporting summary numbers. I want my user to doubleclcik on the currency field and the detail supporting that sum total, pops up...