expression help

[Guest]

Item Reference: "Date " & [Document Date] & " Amount $" & [Outstanding
Balance]
I have the above expression to populate a field in a table using an append
query. My problem is that the [Document Date] field is coming through in
mm/dd/yyyy format and I want it in mm/dd/yy format. The source table has a
format of mm/dd/yy. Can I have an example of an Input mask or Format for
this. Thanks for your help.

 

[Rick Brandt]

Item Reference: "Date " & [Document Date] & " Amount $" &
[Outstanding Balance]
I have the above expression to populate a field in a table using an
append query. My problem is that the [Document Date] field is coming
through in mm/dd/yyyy format and I want it in mm/dd/yy format. The
source table has a format of mm/dd/yy. Can I have an example of an
Input mask or Format for this. Thanks for your help.

Item Reference: "Date " & Format([Document Date], "mm/dd/yy") & " Amount $"
& [Outstanding Balance]

 

[Guest]

Thanks works great. This is exporting the data to a field that is used to
give more information only.

try

Item Reference: "Date " & Format([Document Date], "mm\/dd\/yy") & " Amount
$" & [Outstanding Balance]

btw, hopefully you have a valid business reason for storing two data
elements in a single Text field in your table; if not, you may want to
reconsider doing so.

hth

Item Reference: "Date " & [Document Date] & " Amount $" & [Outstanding
Balance]
I have the above expression to populate a field in a table using an append
query. My problem is that the [Document Date] field is coming through in
mm/dd/yyyy format and I want it in mm/dd/yy format. The source table has a
format of mm/dd/yy. Can I have an example of an Input mask or Format for
this. Thanks for your help.