By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Adding additional value to Row source

P: n/a
Hi

I have a query as a rowsource to a list. Is it possible to add a single
additional value to the row source to appear in the list in addition to what
is coming from the query? Such as by union of the query with the fixed
value?

The reason I need is that I have several values coming from the query but I
also need to add 'ALL' in the list for user to select which is not coming
from the query.

Thanks

Regards
Aug 7 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
see http://www.mvps.org/access/forms/frm0043.htm

hth
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:mo********************@pipex.net...
Hi

I have a query as a rowsource to a list. Is it possible to add a single
additional value to the row source to appear in the list in addition to
what
is coming from the query? Such as by union of the query with the fixed
value?

The reason I need is that I have several values coming from the query but
I
also need to add 'ALL' in the list for user to select which is not coming
from the query.

Thanks

Regards


Aug 7 '06 #2

P: n/a
On Mon, 7 Aug 2006 01:27:37 +0100, John wrote:
Hi

I have a query as a rowsource to a list. Is it possible to add a single
additional value to the row source to appear in the list in addition to what
is coming from the query? Such as by union of the query with the fixed
value?

The reason I need is that I have several values coming from the query but I
also need to add 'ALL' in the list for user to select which is not coming
from the query.

Thanks

Regards


Select YourTable.FieldName From YourTable Union Select ('<ALL>') from
YourTable Order by FieldName;
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.