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
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