Formatting a date

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I'm using the dates derived from criteria entries in a
query as part of the header in a report. Is it possible
to format these dates or must they remain as they were
entered in the query? Thanks!
 
You can use a control source like:
="Dates from " & Format([Enter Start], "mmmm d") & " to " & Format([Enter
End], "mmmm d")
 
Thanks!
-----Original Message-----
You can use a control source like:
="Dates from " & Format([Enter Start], "mmmm d") & " to " & Format([Enter
End], "mmmm d")

--
Duane Hookom
MS Access MVP


I'm using the dates derived from criteria entries in a
query as part of the header in a report. Is it possible
to format these dates or must they remain as they were
entered in the query? Thanks!


.
 
Back
Top