Problem with If.... Then.... Else.... Statement
sorry Jeff
I have no idea how to go about what you are suggesting.
Richard
"Jeff Boyce" wrote:
No, that wasn't what I was suggesting. In the code you were comparing to a
string. Why not do that comparison in a query before getting to the report?
Regards
Jeff Boyce
Microsoft Office/Access MVP
"richard" wrote in message
...
Jeff
If I understand you right would this be as follows
Have the signatures stored as objects in a table??? (the signatures are a
JPEG file stored on the server. Not sure how to do this but will go away
and
have a look) and then pull this object into the query based upon criteria
for
the Analysts Name. This field can then be put into the report straight
from
the query.
Thanks
Richard
"Jeff Boyce" wrote:
Richard
Another approach might be to do the comparison in a query underlying your
report.
Regards
Jeff Boyce
Microsoft Office/Access MVP
|