Add string to expression in Control Source

[jmitchelldueck]

Hi,

Is it possible for one to add a string of text to an Access expression in the control source of a report? For example, one of the defaults on a report is to display the date at which the report was created. Is there a way to say: "This report was created on " [Date] "at " [Time]?

Thanks.

[June7]

Use concatenation.

= "This report was created on " & [Date] & " at " & [Time]?

Date is a reserved word. Should not use reserved words as field names.

[ItsMe]

Yes, you would use the On Format event of the appropriate section.
="This report was created on " & Date & " at " & Now

[orange]

You do not have to add anything in the reports recordsource. You could include the inherent function Now() -- to the control and that will provide the Date and Time in 1 string.
If you want 2 separate strings then use Date() and Time().

[June7]

Yes, if you want the current date/time, not some values from a record, use date/time functions.

[ItsMe]

Yes, if you want the current date/time, not some values from a record, use date/time functions.

I was thinking fields too. After I posted, I read the literal strings included in the expression and figured the OP was wanting the function. I edited my post by removing the brackets at that point.