INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access Howto:

Use UNION statement in SQL to create a dummy record. by Klopper
Posted: 2 May 02

Picture this:
A combo box on a form has an SQL statement for a row source:
Eg. "SELECT DISTINCT City FROM tblCustomer"

This obviously populates the combo box with a unique list of all the cities in the tblCustomer table.  Lets say the the users makes a selection from the combo box to run a sales report by city - by using the SELECT DISTINCT statement as a row source, the combo box will always show all the cities in the table.

To provide the user with an option to run the sales report for ALL cities, use the UNION statement to create a dummy record:
Eg. "SELECT DISTINCT City FROM tblCustomer UNION SELECT 'ALL' AS City FROM tblCustomer"



Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close