Category Archives: Queries
Making the Grade
This month, Doug Steele looks at a common problem in database design: converting from one data classification schema to another. He then moves on to a related question: ensuring that there are no overlapping records in a list of ranges … Continue reading
Locking Columns In A Query
I wanted to lock a column in a query and I just couldn’t be bothered making a a form. Then it occured to me I could add a blank space into the columns that I wanted locked and the user … Continue reading
Give Me a Call
This month, Doug Steele looks at an approach to analyzing telephone logs. I work at a call center. I have a log table containing information about each call received–when the call started, when it completed, and which agent handled the … Continue reading
Doing Two Things at Once
This month, Doug Steele looks at how to update and insert in one step. If I’ve got new data, how can I process it so that matching rows in my master table are updated, and new rows are inserted? I … Continue reading
Consolidating Your Data with Queries
Here’s a comprehensive look at how you can use consolidation queries in Access. And we’re not just talking about how to use Group By, either. Microsoft Access’s Query/SQL environment, along with its support of functions and complex expressions, makes Access … Continue reading
