Solved

Accesss export with formatting

Posted on 2013-01-23
3
384 Views
Last Modified: 2013-01-23
Dear Experts,

I have a database that uses a few fields that is of data type Date/Time, and want to use is as a time field, such as 6:13.
I am  able to display as such within Access, but when I export to Excel, the whole info comes, date, time with AM/PM.
How can I just export the way I am displaying?
Please advise.
0
Comment
Question by:yballan
3 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 38812553
Build a query that formats the field the way you want, and then export that query. For example:

SELECT Field1, Field2, Format(Field3, "hh:mm:ss") AS MyTimeField FROM MyTable

Save the query, and export it instead of a table.
0
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 250 total points
ID: 38812558
try using a query and format the field, like this

select format([dateField],"h:nn")
from tableName

save the query
then export the query
0
 

Author Closing Comment

by:yballan
ID: 38812628
thank you, that makes sense!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now