I have used the following code in the control source of a field to merge two fields:
=[Account Ref] & "" & [Year]
When I go to preview the report, I notice that the field is fine with the account ref part, however the year section is returned with the time and today's date.
The field [Year] has its control source set at Now() with format as yy (This appears fine in the report preveiw).
I hav tried using Date()in this field, but whenever I go to report preveiw it asks me for the parameter value.
I look forward to anybody's help
=[Account Ref] & "" & [Year]
When I go to preview the report, I notice that the field is fine with the account ref part, however the year section is returned with the time and today's date.
The field [Year] has its control source set at Now() with format as yy (This appears fine in the report preveiw).
I hav tried using Date()in this field, but whenever I go to report preveiw it asks me for the parameter value.
I look forward to anybody's help