DOB to print 01/01/xx on report

T

Tina

I have a report with employees date of birth and need to "X" out the year
when printing. Can someone help ??

Thanks!
 
S

SA

Tina:

You can in your report's query alias the dob field and use the format
function to format the dob as you desire like this:

DOB: format([YourDOBFieldName],"mm/dd/xx")

Note that if your table field is DOB, then you have to use a different alias
name such as DOBMasked:
 
J

John Spencer

Use the format function and format the control as "mm/dd"
If you require x's for the year then try "mm/dd/xxxx"
 
Top