How do I add extra row to Union query results?

#11

On Apr 30, 1:17*pm, "David-W-Fenton" <NoEm... (AT) SeeSignature (DOT) invalid>
wrote:

Quote:

emanning <emann... (AT) kumc (DOT) edu> wrote innews:17783eb3-ee8b-4fe6-9417-f3257b228cac (AT) f2g2000yqf (DOT) googlegroups.com
:

I want to query data from a table and add an extra row to the
results.

Sounds to me like you want to create a report.

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
contact via website only * *http://www.dfenton.com/DFA/

Sorry, I don't understand what you mean by this. No, I don't want to
create an Access report. I want to create a list for a combobox.
This list is based on a table and is used in other comboboxes. The
user wants "N/A" to be an option in this particular combobox but not
in others. Creating a union query was the only way I could think of
to accomplish this.

#12

emanning <emanning (AT) kumc (DOT) edu> wrote in
news:e2cf78bd-cb46-4c53-9908-5e290fe7f7ef (AT) d28g2000yqc (DOT) googlegroups.co
m:

Quote:

On Apr 30, 1:17*pm, "David-W-Fenton"
NoEm... (AT) SeeSignature (DOT) invalid> wrote:
emanning <emann... (AT) kumc (DOT) edu> wrote
innews:17783eb3-ee8b-4fe6-9417-f3257b2
28cac (AT) f2g2000yqf (DOT) googlegroups.com
:

I want to query data from a table and add an extra row to the
results.

Sounds to me like you want to create a report.

Sorry, I don't understand what you mean by this. No, I don't want
to create an Access report. I want to create a list for a
combobox. This list is based on a table and is used in other
comboboxes. The user wants "N/A" to be an option in this
particular combobox but not in others. Creating a union query was
the only way I could think of to accomplish this.

Sorry -- I think I mixed up your post with someone else's, where the
request was for a totals row.

The UNION is the correct way to do this, yes. It's a FAQ, actually
(i.e., a question we see quite often).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I add extra row to Union query results?

comp.databases.ms-access comp.databases.ms-access

Re: How do I add extra row to Union query results? - 05-02-2011 , 08:25 AM

Re: How do I add extra row to Union query results? - 05-05-2011 , 03:23 PM