Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to change field properties of already populated base table?

Background; Way back I imported Calc data into Base but one of the columns - Date Issued - is a text(VARCHAR) field. I want to change properties of this column to Date to permit searching between dates. My initial attempts with ALTER TABLE "Table Name", ALTER COLUMN "Column Name" DATE; do not work. Any suggestions would be valued. Thanks.