Ok, this is a good one. In Excel, if you have a sheet full of data, you can easily spot your range. Click one cell in the data (not outside the range), and press CTRL + A. This selects only the data in the range! If you are outside of the range, it will select […]
There are several answers to this question. Here is what I know! Relationships help us with reporting and ensure we don’t put data where it shouldn’t be. They are requirement for reporting on two or more tables for typical reports. Why do they all not have them? Relationships often make it hard for the programmer […]
For years when I have programmed VBA for the Office Suite, I have taken advantage of my CTRL + SPACEBAR shortcut to drop a list of available commands. In Crystal Reports the other day, I had a student bring it to my attention that Crystal does it too! Next time you build a formula in […]
Recent Comments