Formatting the results of a Make Table Query when running it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Night Owl - 20 May 2005 23:03 GMT

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

Reply to this Message

fredg - 21 May 2005 02:03 GMT

> Is it possible to do this, or does it make better sense to format the fields
> in a form based on the table?
[quoted text clipped - 13 lines]
>
> Pete

SELECT DISTINCT Format([FSRef],"@@@\/@@@@@\/@@@") AS FSRef2,
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;

After the new table is made, change the name of the field from FSRef2
back to FSRef.

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message

Night Owl - 21 May 2005 09:17 GMT

Excellent, thank you.

Pete

>> Is it possible to do this, or does it make better sense to format the
>> fields
[quoted text clipped - 25 lines]
> After the new table is made, change the name of the field from FSRef2
> back to FSRef.

Reply to this Message