export query to fixed width text

[eladz949]

hello



im trying to export a query to fixed width text.
i have a field of short date and i need it to be 8 characters.
im using the access export wizard and it adds spaces to the date so what happens is that the date is cut, for example 24/10/2010 is shown as 24 10.
how can i fix this????

thanks!!!!!!!

[RuralGuy]

I would use a query and the Format() function to get the value in the format you want. Format([YourdateField],"ddmmyyyy")

[eladz949]

thanks a lot for the fast reply!

where exactly do i put this format function?

[RuralGuy]

In the query as a new field. NewDateField: Format([YourdateField],"ddmmyyyy")

[eladz949]

it did the trick, many thanks

[RuralGuy]

Excellent! Thanks for posting back with your success. Happy New Year!