Well you can either use Round function in your SQL statement or you can use a Round function in your Load/Display Event on the form.
--- On Mon, 3/2/09, dhimk <[email protected]> wrote: From: dhimk <[email protected]> Subject: [Access VBA Central] HELP IN GETTING ROUNDED FIGURE DATA To: [email protected] Date: Monday, March 2, 2009, 6:39 AM Hii, Can any one please help me on the following? I am trying to make salary slip for around 400 employees in access. I have an excel data sheet where the amount is rounded off but whenever I try to see it in access it comes in decimal figure .what can I do to get the data in access without decimal point as it is in excel sheet. RRGARDS Mark [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
