fbpx

Access queries help and tips

Using SQL Views to Add/Edit Data in Microsoft Access

Using SQL Views to Add/Edit Data in Microsoft Access This is part II of a two part series on views I've written, you can see part I here. Over the last couple of years I have had a great deal of experience with working on Access Databases with the Data is linked to tables in stored in SQL Server. Wi [...]

Using SQL Views to Add/Edit Data in Microsoft Access2021-06-11T05:46:25-05:00

Find All Queries That Use a Particular Table

Find All Queries That Use a Particular Table We just completed a massive 39 database conversion to SQL Server for a client in Tennessee which was quite challenging, we had to not only upsize all the tables, but switch the system from importing/exporting between databases to using linked tables inste [...]

Find All Queries That Use a Particular Table2021-06-11T07:37:34-05:00

Reporting More Granularly Than Usual – Microsoft Access

Reporting More Granularly Than Usual - Microsoft Access Typically, when we do reporting, we usually do it at a higher granularity. For example, clients commonly wants a monthly report of sales. The database would store the individual sales as a single record, so it's no problem summing up the figure [...]

Reporting More Granularly Than Usual – Microsoft Access2021-06-11T07:39:55-05:00

Access User Groups

The purpose of this group is to create virtual chapters throughout the world, from beginning user groups to advanced topics such as SQL Server. Chapters can be organized around a language, such as Spanish, a region, such as Spain or a topic of interest, such as Access functions. We hold monthly meet [...]

Access User Groups2014-07-14T22:52:49-05:00

Whether to exists or not exists, that is the question…

This is second part of 2-part series on SQL clauses. Juan covered the IN() in the first part. We now turn to a close sibling, EXISTS clause. As Juan demonstrated, IN() can be useful for some situations where we want to match a subset of another table without necessarily changing the output due to jo [...]

Whether to exists or not exists, that is the question…2021-06-10T10:02:29-05:00

Are you IN or are you out? (Not IN)

This is a part one of two-part on how you can make your queries much more powerful. In first part, we look at whether we're in or not. Part two can be found here. The IN clause is a great tool to have in your arsenal, it can allow your forms to be editable or filter forms using . What is the IN clau [...]

Are you IN or are you out? (Not IN)2021-06-10T10:01:32-05:00

Matching records using a date range

The other day I asked Ben to help me with a thorny problem, I needed to match records in one table with records in another table using a date range. Here's the table I needed to update, called tblWidgets: WidgetID DateProduced WidgetWeekID ------- ------------ ---- 1 1/2/11 2 1/16/11 3 1/31/11 Widge [...]

Matching records using a date range2021-03-18T07:36:48-05:00

Code to help you debug SQL code – POPQuery

I use SQL in my code a lot, I'm not a fan of creating queries and then referencing them in my code  since users may delete or change them. Often I build SQL strings and then I need to debug them in the query Access grid, in the past I would get the value of my SQL string in the immediate window and [...]

Code to help you debug SQL code – POPQuery2010-10-22T16:03:51-05:00

Criteria for the current month in a query

The other day I needed to create a query where it returns all records with dates for the current month. I did not want to hard code the beginning and ending dates in the query, so I came up with the following line of code you can paste into your query: Between CDate(Month(Date()) & "/1/" &am [...]

Criteria for the current month in a query2009-11-06T10:55:52-06:00
Go to Top