Can't copy conditional result from access to excel

M

Marc Baker

I have a column generated with an IIF statement that appears fine in my
datasheet view in Access but when trying to paste this into Excel I get blank
values. I've tried copying and pasting as well as exporting to no avail.
Any advice? Thanks.
 
T

tina

do you mean you're using an IIf() function in a calculated field in a query?
or using it in a calculated control in a form? please give details of your
scenario.
 
A

adsl

Marc Baker said:
I have a column generated with an IIF statement that appears fine in my
datasheet view in Access but when trying to paste this into Excel I get
blank
values. I've tried copying and pasting as well as exporting to no avail.
Any advice? Thanks.
Click to expand...
 
A

adsl

tina said:
do you mean you're using an IIf() function in a calculated field in a
query?
or using it in a calculated control in a form? please give details of your
scenario.
Click to expand...
 
Top