export query to dbase with fixed field length

[Song Su]

I want to export to dBase IV using query. In my query, one of the field is:
Name:[Last] & " " & [First] & " " & [M]

After exported, I opened dBase, this field is 254 long. I tried:
Name:Left([Last] & " " & [First] & " " & [M],20)

but still 254 character long. I just want 20. How to do it? thanks.

 

[Arvin Meyer [MVP]]

Try:

Name:[Last] & " " & [First] & " " & [M] & Space(20 - Len([Last] & " " &
[First] & " " & [M]))

That will give you a column exactly 20 spaces wide with your 3 concatenated
fields.

 

[Song Su]

My table has duplicate records. without 'distinct', it runs fine. with
distinct, it reported 'invalud procedure call'. here is my query:

SELECT DISTINCT Student.SID, [Last] & " " & [First] & " " & [M] &
Space(20-Len([Last] & " " & [First] & " " & [M])) AS Name
FROM Student;

any idea?

Also, my previsous posting got no answer. Here it is:

One of my query field is FL_START_TIME:CINT(START)

My [start] is 4 character field. I want to export to dBaseIV with numerical
field without decimal

After export I opened dBase, this field is 20 character long with 5 decimal.

I want field size 4 without decimal.

Thanks.

Try:

Name:[Last] & " " & [First] & " " & [M] & Space(20 - Len([Last] & " " &
[First] & " " & [M]))

That will give you a column exactly 20 spaces wide with your 3
concatenated fields.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I want to export to dBase IV using query. In my query, one of the field
is:
Name:[Last] & " " & [First] & " " & [M]

After exported, I opened dBase, this field is 254 long. I tried:
Name:Left([Last] & " " & [First] & " " & [M],20)

but still 254 character long. I just want 20. How to do it? thanks.