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
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