home > technical tips

technical tips and notes

Welcome to Technical Tips. Tips are our solutions to problems we have been asked to solve, and help and advice on using Excel, Access and other applications.

Technical Notes is where we write about any issue that we think may be of interest to users and developers.

If you have any views or comments on the Tips or Notes, please e-mail us.

solutions to excel problems

Changing a time into a decimal value
Summing time values
Suppressing the #DIV/0! error
Showing a formula result in a chart legend
The last day of next month
The totaling percentages problem
Criteria for DSUM formulae.
Error 1004

solutions to access problems

Coping with null values in query expression fields
Attaching labels to control objects on a form
Excel-like rounding of numbers
Compacting database/database speed

technical notes

Rounding numbers
Floating point numbers and scaling

disclaimer

DMW Consultancy Ltd does not accept any liability for loss or damage to data to which any of our Technical Tips solutions are applied. Back up your data; test thoroughly before using on live data.