G Guest Jan 30, 2006 #1 I have a report with employees date of birth and need to "X" out the year when printing. Can someone help ?? Thanks!
I have a report with employees date of birth and need to "X" out the year when printing. Can someone help ?? Thanks!
S SA Jan 30, 2006 #2 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:
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 Jan 30, 2006 #3 Use the format function and format the control as "mm/dd" If you require x's for the year then try "mm/dd/xxxx"
Use the format function and format the control as "mm/dd" If you require x's for the year then try "mm/dd/xxxx"
