Create a 3rd field from parts of two others (1 Viewer)

[tanc]

Hi I have a database for mapping out site location with an Eastings and Northings fields but i need a 3rd field for the grid reference which is built up of two letters and parts of the Eastings and northings (British grid system)

for example Northing:123456 Easting:78900 would be gridreference XX23457890

So it needs the the 2nd to 5th number from the Northing and the first 4 of the Easting

Is there a way to automatically create this field with a query or will it be manual entry

 

[MarkK]

Check out the Left() function, which you can use to create a calculated field in a query like . . .

GridRef: "XX" & Left([SomeField], 4) & Left([OtherField], 4)

Also check out the Mid() function if you need to grab text from the middle of a string.

 

[tanc]

Thanks, I knew it would be something simple