I am trying to combine two fields into 1 with a query.
This is the field in the query. It works fine. However, [HsAbsent]is a numeric field with inputmask = 0.00. So even the whole numbers are in the table with 2 blank decimal points. This is the way I need it. But then when they are combined in the query below it doesn't show the last two decimal places unless something was entered in them like 1.23. Well this throws off the alignment of the
This is the field in the query. It works fine. However, [HsAbsent]is a numeric field with inputmask = 0.00. So even the whole numbers are in the table with 2 blank decimal points. This is the way I need it. But then when they are combined in the query below it doesn't show the last two decimal places unless something was entered in them like 1.23. Well this throws off the alignment of the
Code:
off two places on some lines.
How can I get the HrsAbsent to display the trailing zeros?
Expr1: [HrsAbsent] & " " & [Code]
