Just use the ROUND function like this in the Query Designer: make a new field say called SalesTax:ROUND([SaleTax],2) what this will do is Round off your number 2 places in your field if it was called SalesTax in the Table. Enjoy, ~GeneBat_1999
--- In [email protected], Dennis Jensen <djensen...@...> wrote: > > 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 dh...@... wrote: > > From: dhimk dh...@... > 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] > [Non-text portions of this message have been removed]
