D
Del
I have a query driven report the has a field called "ClockDate" and a
field called "UserID", I want to attach a Sub-Report which has a field
called "date" and a field called "UserID". I want to link the Subform
records to the main form by "UserID" to "UserID" and "ClockDate" to
"date".
The problem is the "ClockDate" field in the report is a Text field and
the "date" field in the Sub-Report is a Date/Time field.
If I open the properties of the "ClockDate" field and select format it
is blank.
Is there a way to change the format of the "ClockDate" field on the
form?
I don't want to change any format settings on the table as it may
cause other issues with links to other tables, queries etc.
Thank you!
field called "UserID", I want to attach a Sub-Report which has a field
called "date" and a field called "UserID". I want to link the Subform
records to the main form by "UserID" to "UserID" and "ClockDate" to
"date".
The problem is the "ClockDate" field in the report is a Text field and
the "date" field in the Sub-Report is a Date/Time field.
If I open the properties of the "ClockDate" field and select format it
is blank.
Is there a way to change the format of the "ClockDate" field on the
form?
I don't want to change any format settings on the table as it may
cause other issues with links to other tables, queries etc.
Thank you!