Link to home
Start Free TrialLog in
Avatar of Fritz Paul
Fritz PaulFlag for South Africa

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.
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
What SQL are you using to create the make-table?  Dates are actually stored as double precision numbers, so I can see how they might translate to a numeric field in  a make-table.  You might try explicitly typing those fields, something like:

SELECT Field1, Field2, cDate(yourTable.Field3) as Field3
INTO yourNewTable
FROM yourFormQuery