Changing header and footer details in queries???????

  • Thread starter Thread starter duncanjx
  • Start date Start date
D

duncanjx

Reports are simple in design view but queries are what I am interested
in.
I have not found a way to alter the header information in a query
other than to turn it off.
Is there a way to add information????
Cheers
Duncan
 
Duncan,
open the query in design view
put the cursor in a column of the query
open the query's property dialog
in the row for Caption, type the name to show for the heading for that
column.

To do this in a more automatic way,
create a calculated field for that column by putting the heading followed by
a colon in front of that field

Example
Field called ODate
in the row for Field for ODate
put Order date:[ODate]

the above will give the name Order date for the caption for that field.

Jeanette Cunningham
 
Reports are simple in design view but queries are what I am interested
in.
I have not found a way to alter the header information in a query
other than to turn it off.
Is there a way to add information????
Click to expand...


Not to a query. That's one of the advantages of using forms
and reports.
 
Back
Top