Formatting Field in a Query for text export

[sam.eade]

Hi all,

I’m currently using an expression in a query to count the amount of records in a separate query. For example, it will show how many sales there are on a given day.

This is the expression I am using,

 Record Count: DCount("*","Export Body1")

I’m trying to export this query into a text file and the output needs to be 8 characters long preceded by 0’s.
i.e. if there are 13 sales, I need the output to be “00000013” but if there was just one sale it would be “00000001”.

Can anyone help me with how to format this? I have limited SQL and VBA knowledge but if you spelled it out for me I’m sure I could input the code.



Thanks

[ranman256]

format(DCount("*","Export Body1"),"00000000")