adding text field to e-mail data collection query

  • Thread starter Thread starter Philip
  • Start date Start date
P

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.
 
use a query and have something like

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

Regards
Kelvan
 
Back
Top