Quick Tips
Numbers in Microsoft Access

This tip that looking at numbers in Microsoft Access, looks at
Whole Numbers . Has there ever been a time when you wish to return how many whole numbers are in a division equation, without the decimals. As an example, how many 6’s are there in 32.

If you used the usual Access formula:


then the result would be:

5.333333 etc.

You could try rounding the number or setting the decimal place to display only integers, but both of these may not give you the correct result each time. i.e. it may either round them up or down.

A quick and easy way is to use the following formula:


Note the slash is a back slash instead of the normal forward slash of the division key.

This formula will give you the result of:


Remember, if using this formula in a form or report, add an = sign to the beginning.

Adding Sequential Numbers to a Report

The adding of sequential numbers to a report is the answer to one of the questions I have received in the past. I have made the assumption that if one person asks the question then it is likely others also wish to know the answer to the question.


How do I get serial line numbers to appear on a report in Access?


To add serial (sequential) numbers for a report:

Add an unbound text box to the design section of the report;

Then, open the text box properties (right click and select properties);

Set the following under the ‘Data’ tab:

Control source '=1'

Running Sum = 'Over Group’ if you wish to count the records in each group


Running Sum = 'Over All' if you wish to display consecutive numbers for all the records.