Look up the Format function (i.e formatting numbers). In your query you can put in the blank column of a field row an expression which is something like MyNumber: Format([FieldNamehere],"#,#0.0") or something like that (not sure on the exact format of the "#,#0.0" or maybe try "###0", etc.). There's different ways you can format the field. There's also other ways to do this. This is one way to get the numbers to display the way you want in the query. Looking up the help on Format of numbers will give you options on how you want to display the number. Someone else will probably show you the right format on the way you want it displayed but hopefully this leads you in the right direction. Also, since it's a text field, you may also need to do some kind of convert function with the format function (look up in the help converting text to numbers). I can't think off of the top of my head what that would be. Sorry, I'll try to get you more info if you don't get some other responses but the idea is that you can use expressions in a query to change the way you want certain fields displayed. You could also consider changing the text field to an integer data type in the table itself (unless you also store alpha characters in the same field). As an integer data type you can still change the way you want it displayed (i.e. with leading 0's).
Last edited by pkstormy; 09-09-06 at 21:15.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)