98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access Rounding Numbers
Access Rounding Numbers
Resolved · Low Priority · Version 2010
Tue 29 Apr 2014, 16:16Delegate Nicole said...
Nicole has attended:
Access Advanced course
Access VBA course
Access Rounding Numbers
Hi there,
Access is rounding numbers.
The information is selected from a date range that the user inputs into a text box within a form.
Which then shows results in another form.
However I'm finding that in the query the form is based on the figures are as expected for example £69.20 however when pulled into a form it displays £69.
Can you help?
Nicole
Tue 29 Apr 2014, 16:48Trainer Jens said...
RE: Access Rounding Numbers
Hi Nicole,
Thank you for the question.
If you open up he form in design view and look at the property sheet (if he property sheet is not open right click the unbound textbox containing your values and click properties).
Have a look at the Format properties and decimal places. If you select currency as format property you should get the figures as you want them.
Please tell me if this didn't do the job.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
Tue 29 Apr 2014, 17:09Delegate Nicole said...
RE: Access Rounding Numbers
Hi Jens,
Thanks for responding.
I've given it a go and it still doesn't work
Wed 30 Apr 2014, 08:29Trainer Jens said...
RE: Access Rounding Numbers
Hi Nicole,
If the data type is number (if it is number the field size must be single or double) or currency in the source table, in the query and in the form, it is difficult to say why the form shows an integer.
If you want me to have a look at your database, you can send it to me, and of course I will handle your data confidential and delete it afterwards.
You can forward the file to info@stl-training.co.uk
Just add my name in the subject.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
Wed 30 Apr 2014, 10:47Delegate Nicole said...
RE: Access Rounding Numbers
Not sure how to send the table is an ODBC Data source,
I 've had a look at the field size and is 'Decimal'.
Fri 2 May 2014, 09:29Trainer Jens said...
RE: Access Rounding Numbers
Hi Nicole,
I have had some time with Google and I have also talked to the other Best STL trainers with Access experience and no one can explain what is wrong. If all fields are set up to decimal and number of decimals are set to 2 you should see the decimals in the form.
I have also tried to simulate your database to see if I could do something to get the same problem, but I couldn't.
I do not know how your database is set up, but if it is possible to send the file I can have a look at it.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
Fri 9 May 2014: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Action queriesUnlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read. |
