Re: Help w/ Union Queries
From: Dave Peterson (ec35720_at_netscapeXSPAM.com)
Date: 01/12/05
- Next message: Dave Peterson: "Re: Excel"
- Previous message: Dave Peterson: "Re: Print the results of a search"
- In reply to: Jenn: "Help w/ Union Queries"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 Jan 2005 19:07:58 -0600
There are lots of people who use access that frequent these Excel newsgroups.
But if you don't get an answer, you may want to post in an Access newsgroup.
Jenn wrote:
>
> ?Can anyone tell me how to make a Union Query. I am not very advanced in
> Access. I need to make a combo box that allows the user to select all or
> just one item. The response back suggested I make a union query to do this.
>
> Currently my combo box row source is from a table called "Project".
> The response from the community told me to do the following but I am lost.
> Thanks in advance for your help!
>
> Response:
> Use a Union query as the row source for your combo box:
>
> Select "All"
> From SomeTable
> UNION
> Select SomeField
> From SomeTable;
-- Dave Peterson
- Next message: Dave Peterson: "Re: Excel"
- Previous message: Dave Peterson: "Re: Print the results of a search"
- In reply to: Jenn: "Help w/ Union Queries"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
