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!

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

Format question

Status
Not open for further replies.

johngordon

Technical User
Jun 29, 2002
112
US
Can someone take a look at the expression below and explain to me how I would format to meduim time.

="Date/Time Received: " & [Forms]![Main]![DATE_RECEIVED] & " " & [Forms]![Main]![TIME_RECEIVED]

This output displays on a report.

Thanks,

Juan
 
="Date/Time Received: " & [Forms]![Main]![DATE_RECEIVED] & " " & Format([Forms]![Main]![TIME_RECEIVED], "Medium Time")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top