Fritz Paul
asked on
Cannot format field in report in date format
I use a create table query to create a table from data in a form.
Two of the fields are date fields on the form, but when the table is created, these fields are stored in number format in the table. Then when I create a report from the table, the numbers are displayed in the report and I cannot format it in date format. There are only options to format as other variants of the number but not as a date.
Can anyone help please.
Two of the fields are date fields on the form, but when the table is created, these fields are stored in number format in the table. Then when I create a report from the table, the numbers are displayed in the report and I cannot format it in date format. There are only options to format as other variants of the number but not as a date.
Can anyone help please.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT Field1, Field2, cDate(yourTable.Field3) as Field3
INTO yourNewTable
FROM yourFormQuery