Solved

Cannot format field in report in date format

Posted on 2013-10-22
2
477 Views
Last Modified: 2013-10-22
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.
0
Comment
Question by:Fritz Paul
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39590812
In the textbox controls, just set the Format property to yyyy-mm-dd or similar (just manually type that into the format property).

It should automatically format the numbers to dates for you.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39590857
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
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question