Can't copy conditional result from access to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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...
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy and paste from datasheet to excel 4
Excel Import Into Access 3
Paste Access into Excel 2
Excel VBA 1
Can't add rows in query since copying database from MSSQL2000 to 2 9
Exporting into Excel / Text getting 'chopped off' 3
conditional format fails when copied 1
Help with ACCESS paste from EXCEL 2

Back
Top