field format

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

Guest

Hiya,

I have a query that holds a calculated field. This field states IIf([Status]="Active","",[Return date]).

i.e. If the [Status] field of the record contains "Active", the calculation is "", otherwise it gives a date.

The problem is that this information is sent into an Excel worksheet. I want the data to be sent across as a date - but because some records contain "" in that field it treats it as text. Formatting the date is not sufficient - it actually needs to be a date in Excel. I was wondering if there was a way that I could replace the "" to make the formula leave the field of the record as null rather than "". In that way, hopefully it will read the column as a date rather than text.

Many thanks for any suggestions,

Mike
 
Mike

Have you tried to reverse the condition, and then not have a false result?

In other words

IIf([Status]<>"Active",[Return date],

It worked for me in my little test

Bob Sulliva
 
Back
Top