Access 2003 - Value in Query Field

[stephenj789]

I have a query in Access that has a declared field that looks like this in SQL: "Null AS Affiliate"

The results of the query are copied and pasted into Excel. In Excel the "Affiliate" field is evaluated and is supposed to be nothing (an empty cell), however, the data pasted into Excel in that field contains some sort of data that evaluates the field as not being an empty cell.

My question is this: How can I declare the field "Affiliate" in SQL such that, when copied and pasted into Excel, would equate to an empty cell. In addition to Null, I've tried ' "" AS Affiliate '.

Doing a Google search gives me plenty of information regarding Null vs Empty String, however, no solution as to what to do (if there is anything that can be done).

 

[lameid]

The results of the query are copied and pasted into Excel. In Excel the "Affiliate" field is evaluated and is supposed to be nothing (an empty cell), however, the data pasted into Excel in that field contains some sort of data that evaluates the field as not being an empty cell.

What data is in the cell?

 

[SkipVought]

Use the CODE function to discover the VALUE of the data in your cell.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[stephenj789]

The CODE function returns #VALUE!, but there must be something in there because:

If I go to the first record (in Excel 2003) in the field and press the END key, then the down arrow, it takes me to the last record in the table, rather than row 65536.

If I select the entire field (for all records) and press delete, then go to the first record in the field and press the END key, then the down arrow, it takes me to row 65536.

Anyways, I included a work around in the data validation macro that is used, so this will not be a problem. Thanks for the help.