M
Mary B.
An Access database was developed in Access 97 SR-1. The
user's PC has been updated to SR-2. This resulted in a
concatonated field being truncated. The concatonated field
is created from the following fields on Table A: 1)code(6
digits), 2)century(2 digtis) and 3)month(2 digits)using an
update query. The code for the update query is:
user's PC has been updated to SR-2. This resulted in a
concatonated field being truncated. The concatonated field
is created from the following fields on Table A: 1)code(6
digits), 2)century(2 digtis) and 3)month(2 digits)using an
update query. The code for the update query is:
Code:
&Right([endDate],2)&Left([endDate],2).It populates a
field on Table A and is displayed on report. The input
mask used is 000000\-0000;;-. The correct display is:
999999-0301 where 999999 is the code and 03 is the century
and 01 is the month. It displays and is stored improperly
as 999999-030\. Solutions ?