'Make Table' query in Access XP creates fields as binary type. 1

[kramerica]

sql statment:

SELECT [Enter Effective Date MM/DD/YYYY] AS [Date], [Enter Denial Explanation Code] AS EX INTO [tblParameters];


If you open a new query in Access 2002 - and paste this in the SQL window - and run it, it will create a new table called "tblParameters' - with 2 fields.

Unfortunately the fields are formatted as 'BINARY'!!@#$

Any ideas? Is this a bug in Access XP.

Kramerica

 

[Blorf]

Try this instead:

SELECT DateValue([Enter Effective Date MM/DD/YYYY]) AS [Date], Int([Enter Denial Explanation Code]) AS EX INTO tblParameters;


Ascii dumb question, get a dumb Ansi

 

[kramerica]

We ended up changing the sql statement to:

PARAMETERS [Enter Effective Date MM/DD/YYYY] Text ( 255 ), [Enter Denial Explanation Code] Text ( 255 );

SELECT [Enter Effective Date MM/DD/YYYY] AS [Date], [Enter Denial Explanation Code] AS EX INTO [tblParameters];


By using the parameters it allowed us to force the fields as text. (not sure why they want the [date] to be stored as text.. but it is what it is)

Thanks BLORF - your solution also worked and it was very helpful.

Kramerica