N
Night Owl
Is it possible to do this, or does it make better sense to format the fields
in a form based on the table?
The code I'm using is...
SELECT DISTINCT tblLinkedData.FSRef, tblLinkedData.Premises,
tblLinkedData.Type INTO tblFileReference
FROM tblLinkedData
GROUP BY tblLinkedData.FSRef, tblLinkedData.Premises, tblLinkedData.Type
HAVING (((tblLinkedData.Premises) Is Not Null))
ORDER BY Premises;
....but I'd prefer the FSRef field formatted as 123/12345/123
TIA,
Pete
in a form based on the table?
The code I'm using is...
SELECT DISTINCT tblLinkedData.FSRef, tblLinkedData.Premises,
tblLinkedData.Type INTO tblFileReference
FROM tblLinkedData
GROUP BY tblLinkedData.FSRef, tblLinkedData.Premises, tblLinkedData.Type
HAVING (((tblLinkedData.Premises) Is Not Null))
ORDER BY Premises;
....but I'd prefer the FSRef field formatted as 123/12345/123
TIA,
Pete