J
Jim
I imported a table from Dbase and there is a date column
that has a bunch of #Error for values. I cant copy the
table or do anything if I am trying to access one of these
records. I want to copy the table to a new table using a
Query/Make table. What type of expression can I use that
would say New_Date=if date is #error then ""blank""
else ""use the date that is in the table""
Can't find any examples for this.
Thanks in advance!!!
that has a bunch of #Error for values. I cant copy the
table or do anything if I am trying to access one of these
records. I want to copy the table to a new table using a
Query/Make table. What type of expression can I use that
would say New_Date=if date is #error then ""blank""
else ""use the date that is in the table""
Can't find any examples for this.
Thanks in advance!!!