Merry Christmas & hope you are anjoying your cold turkey sandwiches (I am).
I have a query with one field that concatonates five other fields in the query, thus:
RfiRef: "RFI" & "-" & [ProjectNo] & "-" & [TaskNo] & "-" & [RfiNo] & "-" & [RfiIssue].
RfiNo and RfiIssue are fomatted in thier tables as three digt numbers eg 003.
When I display RfiRef in a textbox, RfiNo and RfiIssue display as:
RFI-80001-41r-3-4.
I want the textbox to show:
RFI-80001-41r-003-004.
How do I do that? Do I format the textbox or the query or something else?
Cheers
David
I have a query with one field that concatonates five other fields in the query, thus:
RfiRef: "RFI" & "-" & [ProjectNo] & "-" & [TaskNo] & "-" & [RfiNo] & "-" & [RfiIssue].
RfiNo and RfiIssue are fomatted in thier tables as three digt numbers eg 003.
When I display RfiRef in a textbox, RfiNo and RfiIssue display as:
RFI-80001-41r-3-4.
I want the textbox to show:
RFI-80001-41r-003-004.
How do I do that? Do I format the textbox or the query or something else?
Cheers
David