From: Eva on
Hi
I have two querries that are the same, except I have the criteria:
- on column called Ble service - one query asks for items "TTO" the other
for "OPPO"
When I try to union both queries into one using sql (union all) then on the
result the query asks for bble service - I can just type enter and have the
result of the query, but I want to skip it - I just want to click to my union
query and see the results.
I am doing something wrong that it asks me for it?
Thank you

--
Greatly appreciated
Eva
From: KARL DEWEY on
If I understand correctly you do not need a union.
Try this --
SELECT YourTable.*
FROM YourTable
WHERE YourTable.[Ble service] = "TTO" OR YourTable.[Ble service] = "OPPO";

You used [Ble service] and [Bble service] and that is probably why it ask
you to enter a response.

--
Build a little, test a little.


"Eva" wrote:

> Hi
> I have two querries that are the same, except I have the criteria:
> - on column called Ble service - one query asks for items "TTO" the other
> for "OPPO"
> When I try to union both queries into one using sql (union all) then on the
> result the query asks for bble service - I can just type enter and have the
> result of the query, but I want to skip it - I just want to click to my union
> query and see the results.
> I am doing something wrong that it asks me for it?
> Thank you
>
> --
> Greatly appreciated
> Eva
From: KenSheridan via AccessMonster.com on
Eva:

If it is prompting for "bble service" could this be a typo in the query for
"Ble service", which you say is the column name.

But, if both parts are the same apart from the criteria on the column why do
you need a UNION ALL operation at all for this? Can't it be done with:

SELECT *
FROM [YourTable]
WHERE [Ble service] = "TTO"
OR [Ble service] = "OPPO";

Ken Sheridan
Stafford, England

Eva wrote:
>Hi
>I have two querries that are the same, except I have the criteria:
>- on column called Ble service - one query asks for items "TTO" the other
>for "OPPO"
>When I try to union both queries into one using sql (union all) then on the
>result the query asks for bble service - I can just type enter and have the
>result of the query, but I want to skip it - I just want to click to my union
>query and see the results.
>I am doing something wrong that it asks me for it?
>Thank you
>

--
Message posted via http://www.accessmonster.com

From: Eva on
Hi Karl
Thank you for your response. I have in both column called Ble service (there
was a typo), and I tried your suggestion and I got the syntax error message.

If I have two queries I don't need union to join them as one? (the reason I
have two queries that headings are the same is that the information presented
there is different so I coudn't do it in one query)
--
Greatly appreciated
Eva


"KARL DEWEY" wrote:

> If I understand correctly you do not need a union.
> Try this --
> SELECT YourTable.*
> FROM YourTable
> WHERE YourTable.[Ble service] = "TTO" OR YourTable.[Ble service] = "OPPO";
>
> You used [Ble service] and [Bble service] and that is probably why it ask
> you to enter a response.
>
> --
> Build a little, test a little.
>
>
> "Eva" wrote:
>
> > Hi
> > I have two querries that are the same, except I have the criteria:
> > - on column called Ble service - one query asks for items "TTO" the other
> > for "OPPO"
> > When I try to union both queries into one using sql (union all) then on the
> > result the query asks for bble service - I can just type enter and have the
> > result of the query, but I want to skip it - I just want to click to my union
> > query and see the results.
> > I am doing something wrong that it asks me for it?
> > Thank you
> >
> > --
> > Greatly appreciated
> > Eva
From: Eva on
It works now! thanks both of you !
--
Greatly appreciated
Eva


"KenSheridan via AccessMonster.com" wrote:

> Eva:
>
> If it is prompting for "bble service" could this be a typo in the query for
> "Ble service", which you say is the column name.
>
> But, if both parts are the same apart from the criteria on the column why do
> you need a UNION ALL operation at all for this? Can't it be done with:
>
> SELECT *
> FROM [YourTable]
> WHERE [Ble service] = "TTO"
> OR [Ble service] = "OPPO";
>
> Ken Sheridan
> Stafford, England
>
> Eva wrote:
> >Hi
> >I have two querries that are the same, except I have the criteria:
> >- on column called Ble service - one query asks for items "TTO" the other
> >for "OPPO"
> >When I try to union both queries into one using sql (union all) then on the
> >result the query asks for bble service - I can just type enter and have the
> >result of the query, but I want to skip it - I just want to click to my union
> >query and see the results.
> >I am doing something wrong that it asks me for it?
> >Thank you
> >
>
> --
> Message posted via http://www.accessmonster.com
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: I need help
Next: send to email