G Guest Dec 10, 2004 #1 Is there an expression I can use to take just the year from a date field on a form and insert it into a text box on a report:
Is there an expression I can use to take just the year from a date field on a form and insert it into a text box on a report:
F fredg Dec 10, 2004 #3 Is there an expression I can use to take just the year from a date field on a form and insert it into a text box on a report: Click to expand... If the field is included in the report's record source: =Year([DateField]) or.. =Format([DateField],"yyyy") If the form control is not included in the report's record source: =Year(Forms!FormName!ControlName) The form must be open when the report is run.
Is there an expression I can use to take just the year from a date field on a form and insert it into a text box on a report: Click to expand... If the field is included in the report's record source: =Year([DateField]) or.. =Format([DateField],"yyyy") If the form control is not included in the report's record source: =Year(Forms!FormName!ControlName) The form must be open when the report is run.
G Guest Dec 10, 2004 #4 The field is included in the report's record source. Thanks!! fredg said: Is there an expression I can use to take just the year from a date field on a form and insert it into a text box on a report: Click to expand... If the field is included in the report's record source: =Year([DateField]) or.. =Format([DateField],"yyyy") If the form control is not included in the report's record source: =Year(Forms!FormName!ControlName) The form must be open when the report is run. Click to expand...
The field is included in the report's record source. Thanks!! fredg said: Is there an expression I can use to take just the year from a date field on a form and insert it into a text box on a report: Click to expand... If the field is included in the report's record source: =Year([DateField]) or.. =Format([DateField],"yyyy") If the form control is not included in the report's record source: =Year(Forms!FormName!ControlName) The form must be open when the report is run. Click to expand...
