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!
Click to expand...


.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Form for Criteria for Report 3
Conditional Format based on Query criteria 2
Date range in header 4
Linking dates In reports 4
Use combo to print report between two sets of dates 1
Including query dates in report 1
Date Range in Report Header 1
Conditional formatting of date supplied by a form 1

Back
Top