Make table query to format fields (1 Viewer)

[spet]

Hello, I have a make table query that formats data to a table so I can export it to a text file. Currently I am formatting [Field1] like this:
Format([Field1]*10,"00000000") outputs: -00030000. I need this field to only be 8 characters long including the negative(-) sign. Is there a correct way to format this field to make that happen?

Thank you in advance ~ Stacy

 

[theDBguy]

Hi Stacy,

Maybe something like:

Format([Field1]*10,IIf([Field1]<0,"0000000","00000000"))

(untested)
Hope that helps...

 

[spet]

Hi Stacy,

Maybe something like:

Format([Field1]*10,IIf([Field1]<0,"0000000","00000000"))

(untested)
Hope that helps...

Thank you @theDBguy worked like a charm!

 

[theDBguy]

Thank you @theDBguy worked like a charm!

Hi. I'm surprised, but glad to hear it worked. Good luck with your project.