You can use an undocumented Registry key to display a Query Builder tab on the Filter dialog box associated with the View Summary dialog box. After you use the Query Builder to construct your query, you can then copy the Filter syntax displayed on the SQL page and paste it into your code. Do not attempt to add the Query Builder page Registry setting unless you are familiar with the Windows Registry Editor.
To display the Query Builder tab of the Filter dialog box, follow these steps:
- Click Start and point to Run. In the Run dialog box, type Regedit, and then click OK to launch the Windows Registry Editor.
- In the Registry tree, navigate to
- From the Edit menu, select New, and then select Key.
- In the Key edit box, type QueryBuilder. Regedit will suggest New Key #1, but you should replace that key name with QueryBuilder.
If you like this blog or find it useful for you, you are welcome to comment on it. You are also welcome to share this blog, so that more people can participate in it. If the images used in the blog infringe your copyright, please contact the author to delete them. Thank you!