Why does my text not appear?

[David Ball]

Hi,

I get four spreadsheet reports from another department that shows forecast delivery dates. They have a date column that I need to use but insist on having text mixed in with the dates (they type “Delivered” for any item that has arrived).
I have a table based on each of the spreadsheets and I got this working fine in my database by doing some work-arounds but now one of my tables does not accept the “Delivered” text.
The data types involved are:
· Dates in all spreadsheets are Custom type with Format d-mmm-yy
· The text “Delivered” is General type in all spreadsheets
· My Delivery Date field is Text type in all tables
For some reason the text “Delivered” appears in with the dates in the Delivery Date field in three of the tables (what I want) but in the other table when I paste in the data only the dates appear, not the text?
Why is this, when everything appears to be the same in the tables and the spreadsheets?
Thanks very much

Dave

 

[jdraw]

Access provides Date/Time datatype specifically for Dates.

You may want to investigate the CDate() function, Format() function.

A sample of your data (before and after) might help readers.

 

[Ranman256]

you cant turn letters into numbers.

 

[David Ball]

Thanks,

I already use CDate() function and Format() function to get the data how I want it later.

And I'm not trying to turn letters to numbers.

I'm just trying to understand why three tables except the "Deleted" text in the Delivery Date field (along with "Dates" in Text format) and the one table doesn't, when they all use the Text type?