adding text field to e-mail data collection query

[Philip]

I am using a query to collection time card information. HR compliance
requires that the employee "sign" the timecard, including a statement as to
the correctness and veracity of the info.
For the signature, I created a blank field where the employee enters his
initials, but I cannot figure how to have the TEXT statement show on the
e-mail form without being part of the timecard table - a tremendous waste of
space.

 

[Lord Kelvan]

use a query and have something like

select *, "the text statement" as textstatement
from timecardtable

Regards
Kelvan