Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time Format

Status
Not open for further replies.
Dickx

Dickx

Technical User
Aug 24, 2001
33
US
A field in an Access table is formated as Short Time which displays the value as 7:25. If I export this table to a tab delimited text file the same field displays as 12/30/1899 7:25:00. How do I change the format to remove the 12/30/1899.
 
Sort by date Sort by votes
Export a formatted query instead of the table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rccline
  • Locked
  • Question
Highlighting Duplicates with Conditional Formatting 2
2
Replies
26
Views
501
strongm
strongm
Netherby
  • Locked
  • Question
Number Format
Replies
2
Views
63
Netherby
Netherby
DeRochier
  • Locked
  • Question
Conditional formatting on Yes/No fields
Replies
2
Views
157
Axworthy
Axworthy
N2Life
  • Locked
  • Question
Last figure in a text box is partially cut off when conditionally formatted as italics 1
Replies
7
Views
144
N2Life
N2Life
MM1963
  • Locked
  • Question
Access - Autoexec macro only run during a certain time
Replies
10
Views
148
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top