Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Queries: Index of Articles

 
 
Use a parameter to return all records if Null

How to optionally return all records if no value for parameter was specified, that is, it was left NULL

Return database object names

Query the MSysObjects table to return database object names

Open Parameter queries from code

Syntax for opening a recordset on parameter queries from code

Have query return highest/lowest value in a field

How to use the TopValues property

Use a variable in a field's criteria

How to return a variable's value through a function for use in a query

Have a query return every nth record in a table

Use a function with a static variable to return every nth record from a table

Find Unmatched records between two tables

Use the build in wizards

Find Duplicate key values

Use the built in wizards

Solving problems with Dates in SQL

Dates in Access are in US format by default

Create a query that returns Top n records

How to use the Top predicate in SQL

Create a query that returns Random records

How to use a randomizer function

Turn off the default Action query confirmations

How to suppress confirmation dialogs

Too few parameters, expected n

How to identify parameters in inline SQL and correctly provide values via concatenation 

Simplify action queries in code

How to organize multiple SQL statements that are run in a sequence

Handling floating-point, Currency, and Decimal Datatype in SQL

Avoid problems with locales where the decimal point is the separator

Finding all X having all required Y

Steps on how to return records that match the specified criteria 

Fixed column name and crosstabs

Control column names produced by a crosstab query

Continuous sequence, maximum length (stroke)

How to retrieve continuous sequence via SQL

Quartiles, Percentiles

How to calculate Quartiles and Percentiles

Getting a related field from a GroupBy (total) query

How to get additional fields in a Totals query

Merging sequences

How to merge sequences through SQL

Jet-MSDE: DELETE * FROM Table1; Incorrect syntax near '*'

Differences between Jet's ANSI SQL and SQL Server's Transact-SQL

BOM, with Joe Celko Nested Sets

A SQL approach to BOM

 

1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer