Format a number

[tamer64]

I have a query which sums a field which is a number. How do I format it so it shows single digits as 08, 09, 10 and so on instead of 8, 9, 10.

SELECT T_099_Equip_Maintenance_Table.Equipment_Type, Sum(T_099_Equip_Maintenance_Table.Tag) AS DesktopTotal
FROM T_099_Equip_Maintenance_Table
GROUP BY T_099_Equip_Maintenance_Table.Equipment_Type
HAVING (((T_099_Equip_Maintenance_Table.Equipment_Type)="Desktop"));

 

[dhookom]

I typically don't format anything in a query. I reserve the formatting to the form or report displaying the value. However, you could try:

Format(Sum(T_099_Equip_Maintenance_Table.Tag),"00") AS DesktopTotal

Duane
Hook'D on Access
MS Access MVP

 

[tamer64]

Thank You...worked out fine.