C
Christen
I am using the IF function on a report.
It looks like this: =IF(QUERY!F11=""," ",QUERY!F11). It is pulling data
from a query and then puts it on the main sheet of the report. I am getting
this error... that looks like this:=IF(QUERY!#REF!=""," ",QUERY!#REF!) ... in
5 of the last rows of the report, and then it lists the last record
correctly. So if there are 30 records that are supposed to be pulled over,
it list records 1-25, then 5 rows of the error, then the last record in row
36. I don't know why this is happening. If i go on the main sheet, and copy
the column down over the error cells, it works correctly, but as soon as I
refresh my data, or switch criteria in the query, the error comes up again on
the sheet..... Any ideas??
It looks like this: =IF(QUERY!F11=""," ",QUERY!F11). It is pulling data
from a query and then puts it on the main sheet of the report. I am getting
this error... that looks like this:=IF(QUERY!#REF!=""," ",QUERY!#REF!) ... in
5 of the last rows of the report, and then it lists the last record
correctly. So if there are 30 records that are supposed to be pulled over,
it list records 1-25, then 5 rows of the error, then the last record in row
36. I don't know why this is happening. If i go on the main sheet, and copy
the column down over the error cells, it works correctly, but as soon as I
refresh my data, or switch criteria in the query, the error comes up again on
the sheet..... Any ideas??