Query ResultSet Date

  • Thread starter Thread starter Mona
  • Start date Start date
M

Mona

When printing the results of a query, the date appears in
the header. Is there a way to change the date to include
the actual time of printing, rather than just the date? I
have not been able to find any place that I can change
the expression to =now() or change the format, if the now
expression is the one used. I know I can do it by
creating a form, displayed in datasheet view, but I would
prefer modifying the header of the query result.
 
When printing the results of a query, the date appears in
the header. Is there a way to change the date to include
the actual time of printing, rather than just the date? I
have not been able to find any place that I can change
the expression to =now() or change the format, if the now
expression is the one used. I know I can do it by
creating a form, displayed in datasheet view, but I would
prefer modifying the header of the query result.
Click to expand...


You can either display the entire header and footer or not, (in Page
SetUp) but as far as I know, you have no control over what appears in
the header/footer.

Reports are for printing, not queries or forms.
Create a report, based upon the data in the query.
Now you have control over what shows in the heading.
 
Back
Top