union query challenge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking for a way to select a specific result of a Union Query as a row
source for a combo box. Currently, I cannot specify the exact result I want
because, I'm guessing, they are derived from a single record in a table. Is
there a way around this? I've tried using the Union Query as a subquery in
the row source property, but came up with the same results. Is there any way
to do this without creating a new table?
 
Durn... Thought I had it covered... Anyhow, here's the SQL:

SELECT [Order Number], CompanyName, SpecID, Alloy, [Thick], [Part Number],
[Qty]
FROM [SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 1] as [Thick],
[Order Entry].[Part Number1] as [Part Number], [Order Entry].[QTY 1] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number1]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 2] as [Thick],
[Order Entry].[Part Number 2] as [Part Number], [Order Entry].[QTY2] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 2]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 3] as [Thick],
[Order Entry].[Part Number 3] as [Part Number], [Order Entry].[QTY 3] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 3]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 4] as [Thick],
[Order Entry].[Part Number4] as [Part Number], [Order Entry].[QTY4] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number4]) Is Not Null))
ORDER BY [Order Entry].[Order Number]]. AS [%$##@_Alias]
WHERE [Order Number] is Not Null;

--
Why are you asking me? I dont know what Im doing!

Jaybird


Jeff Boyce said:
Consider posting the SQL statement of your UNION query...

Tough to diagnose if we can't see what you see...


--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
Click to expand...
 
Just a hunch, but it looks like your [Order Entry] table has multiple
repeating "quantity" fields. While this might be the only way to handle
your data if you were using a spreadsheet, Access is a relational database.
You will not get the best use of Access' features and functions if you don't
normalize your data, and you will have to come up with complex work-arounds
to do "simple" things ... (oops, that's what you've just described!).

Tell us a bit more about your underlying data, not about how you are trying
to query it. In your world, what's the relationship among Customers
(?"Contacts"?), Orders, and Order Details? Not how you've structured your
current tables, but something in English like:
One Customer can have multiple Orders
One Order can have multiple Order Details
No Order is for more than one Customer

A more traditional (relational) database structure for orders can be found
in the Northwind database sample that comes with Access. Something like:

tblCustomer
CustomerID
...

tblOrder
OrderID
CustomerID
OrderDate
...

trelOrderDetail
OrderDetailID
OrderID
ItemID
Quantity
...

--
Good luck & Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Jaybird said:
Durn... Thought I had it covered... Anyhow, here's the SQL:

SELECT [Order Number], CompanyName, SpecID, Alloy, [Thick], [Part Number],
[Qty]
FROM [SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 1] as [Thick],
[Order Entry].[Part Number1] as [Part Number], [Order Entry].[QTY 1] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number1]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 2] as [Thick],
[Order Entry].[Part Number 2] as [Part Number], [Order Entry].[QTY2] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 2]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 3] as [Thick],
[Order Entry].[Part Number 3] as [Part Number], [Order Entry].[QTY 3] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 3]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 4] as [Thick],
[Order Entry].[Part Number4] as [Part Number], [Order Entry].[QTY4] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number4]) Is Not Null))
ORDER BY [Order Entry].[Order Number]]. AS [%$##@_Alias]
WHERE [Order Number] is Not Null;
Click to expand...
 
Jeff,

I realize only now that I didn't tell you the whole, sad story... I've
inherited a database that relies heavily on a non-normalized table (Order
Entry). I'm pretty sure you've guessed as much, but the workaround is
designed to provide some functionality to a form I am designing without
having to commit to normalizing the table. (Management is still unsure if I
have the "minerals" to deal with it.) Each record for the Order Entry table
is assigned an Order Number which serves as its primary key. Each Order
Number may have up to four part numbers included on it. In order for these
part numbers to be included on one Order Number, they must have similar
properties and processes to be completed. Similar, but not identical. What
happens is, these different part numbers get split from the original Order
Number and processed separately. I'm designing a form that will avoid order
entry errors that occur in when process data is updated at each stage of the
operation. To do this, it makes sense to refer to the original data on the
Order Number via a combo box... EXCEPT that the original order number has up
to four different part numbers associated with it. John Spencer came up with
a beauty of a query that splits up the Order Entry table into however many
part numbers are included with it. I was hoping to use this query as the row
source for my combo box on the form, but the more I think about it, the more
I'm convinced that this query lacks the reference information to specify a
row of information under the Order Number. (It keeps selecting the first
one.) I need some kind of unique identifyer for the row. All of the methods
I can think of involve appending to (or creating) a table and assigning
reference information there. I can do that. I just wonder if this method is
a little ass-backwards. If I'm going to create a normalized version of the
table (even if its limited) it seems silly to continue working around the old
version. I guess my question is: Do you know of anything that will make my
form act like I want it to, without having to resort to complete
normalization of the Order Entry table?
--
Why are you asking me? I dont know what Im doing!

Jaybird


Jeff Boyce said:
Just a hunch, but it looks like your [Order Entry] table has multiple
repeating "quantity" fields. While this might be the only way to handle
your data if you were using a spreadsheet, Access is a relational database.
You will not get the best use of Access' features and functions if you don't
normalize your data, and you will have to come up with complex work-arounds
to do "simple" things ... (oops, that's what you've just described!).

Tell us a bit more about your underlying data, not about how you are trying
to query it. In your world, what's the relationship among Customers
(?"Contacts"?), Orders, and Order Details? Not how you've structured your
current tables, but something in English like:
One Customer can have multiple Orders
One Order can have multiple Order Details
No Order is for more than one Customer

A more traditional (relational) database structure for orders can be found
in the Northwind database sample that comes with Access. Something like:

tblCustomer
CustomerID
...

tblOrder
OrderID
CustomerID
OrderDate
...

trelOrderDetail
OrderDetailID
OrderID
ItemID
Quantity
...

--
Good luck & Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Jaybird said:
Durn... Thought I had it covered... Anyhow, here's the SQL:

SELECT [Order Number], CompanyName, SpecID, Alloy, [Thick], [Part Number],
[Qty]
FROM [SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 1] as [Thick],
[Order Entry].[Part Number1] as [Part Number], [Order Entry].[QTY 1] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number1]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 2] as [Thick],
[Order Entry].[Part Number 2] as [Part Number], [Order Entry].[QTY2] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 2]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 3] as [Thick],
[Order Entry].[Part Number 3] as [Part Number], [Order Entry].[QTY 3] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 3]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 4] as [Thick],
[Order Entry].[Part Number4] as [Part Number], [Order Entry].[QTY4] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number4]) Is Not Null))
ORDER BY [Order Entry].[Order Number]]. AS [%$##@_Alias]
WHERE [Order Number] is Not Null;

--
Why are you asking me? I dont know what Im doing!

Jaybird


Jeff Boyce said:
Consider posting the SQL statement of your UNION query...

Tough to diagnose if we can't see what you see...


--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

I'm looking for a way to select a specific result of a Union Query as a
row
source for a combo box. Currently, I cannot specify the exact result I
want
because, I'm guessing, they are derived from a single record in a table.
Is
there a way around this? I've tried using the Union Query as a subquery
in
the row source property, but came up with the same results. Is there any
way
to do this without creating a new table?
Click to expand...
Click to expand...
Click to expand...
 
Sorry, no experience down that road. I've focused more on getting my data
in order before trying to use forms against it.

Just one person's opinion...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


Jaybird said:
Jeff,

I realize only now that I didn't tell you the whole, sad story... I've
inherited a database that relies heavily on a non-normalized table (Order
Entry). I'm pretty sure you've guessed as much, but the workaround is
designed to provide some functionality to a form I am designing without
having to commit to normalizing the table. (Management is still unsure if I
have the "minerals" to deal with it.) Each record for the Order Entry table
is assigned an Order Number which serves as its primary key. Each Order
Number may have up to four part numbers included on it. In order for these
part numbers to be included on one Order Number, they must have similar
properties and processes to be completed. Similar, but not identical. What
happens is, these different part numbers get split from the original Order
Number and processed separately. I'm designing a form that will avoid order
entry errors that occur in when process data is updated at each stage of the
operation. To do this, it makes sense to refer to the original data on the
Order Number via a combo box... EXCEPT that the original order number has up
to four different part numbers associated with it. John Spencer came up with
a beauty of a query that splits up the Order Entry table into however many
part numbers are included with it. I was hoping to use this query as the row
source for my combo box on the form, but the more I think about it, the more
I'm convinced that this query lacks the reference information to specify a
row of information under the Order Number. (It keeps selecting the first
one.) I need some kind of unique identifyer for the row. All of the methods
I can think of involve appending to (or creating) a table and assigning
reference information there. I can do that. I just wonder if this method is
a little ass-backwards. If I'm going to create a normalized version of the
table (even if its limited) it seems silly to continue working around the old
version. I guess my question is: Do you know of anything that will make my
form act like I want it to, without having to resort to complete
normalization of the Order Entry table?
--
Why are you asking me? I dont know what Im doing!

Jaybird


Jeff Boyce said:
Just a hunch, but it looks like your [Order Entry] table has multiple
repeating "quantity" fields. While this might be the only way to handle
your data if you were using a spreadsheet, Access is a relational database.
You will not get the best use of Access' features and functions if you don't
normalize your data, and you will have to come up with complex work-arounds
to do "simple" things ... (oops, that's what you've just described!).

Tell us a bit more about your underlying data, not about how you are trying
to query it. In your world, what's the relationship among Customers
(?"Contacts"?), Orders, and Order Details? Not how you've structured your
current tables, but something in English like:
One Customer can have multiple Orders
One Order can have multiple Order Details
No Order is for more than one Customer

A more traditional (relational) database structure for orders can be found
in the Northwind database sample that comes with Access. Something like:

tblCustomer
CustomerID
...

tblOrder
OrderID
CustomerID
OrderDate
...

trelOrderDetail
OrderDetailID
OrderID
ItemID
Quantity
...

--
Good luck & Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Jaybird said:
Durn... Thought I had it covered... Anyhow, here's the SQL:

SELECT [Order Number], CompanyName, SpecID, Alloy, [Thick], [Part Number],
[Qty]
FROM [SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 1] as [Thick],
[Order Entry].[Part Number1] as [Part Number], [Order Entry].[QTY 1]
Click to expand...
as
[Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number1]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 2] as [Thick],
[Order Entry].[Part Number 2] as [Part Number], [Order Entry].[QTY2]
Click to expand...
as
[Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 2]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 3] as [Thick],
[Order Entry].[Part Number 3] as [Part Number], [Order Entry].[QTY 3]
Click to expand...
as
[Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 3]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 4] as [Thick],
[Order Entry].[Part Number4] as [Part Number], [Order Entry].[QTY4] as [Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number4]) Is Not Null))
ORDER BY [Order Entry].[Order Number]]. AS [%$##@_Alias]
WHERE [Order Number] is Not Null;

--
Why are you asking me? I dont know what Im doing!

Jaybird


:

Consider posting the SQL statement of your UNION query...

Tough to diagnose if we can't see what you see...


--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

I'm looking for a way to select a specific result of a Union Query
Click to expand...
as
a
row
source for a combo box. Currently, I cannot specify the exact
Click to expand...
result
I
want
because, I'm guessing, they are derived from a single record in a table.
Is
there a way around this? I've tried using the Union Query as a subquery
in
the row source property, but came up with the same results. Is
Click to expand...
there
any
way
to do this without creating a new table?
Click to expand...
Click to expand...
Click to expand...
 
Well, thanks anyway!
--
Why are you asking me? I dont know what Im doing!

Jaybird


Jeff Boyce said:
Sorry, no experience down that road. I've focused more on getting my data
in order before trying to use forms against it.

Just one person's opinion...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


Jaybird said:
Jeff,

I realize only now that I didn't tell you the whole, sad story... I've
inherited a database that relies heavily on a non-normalized table (Order
Entry). I'm pretty sure you've guessed as much, but the workaround is
designed to provide some functionality to a form I am designing without
having to commit to normalizing the table. (Management is still unsure if I
have the "minerals" to deal with it.) Each record for the Order Entry table
is assigned an Order Number which serves as its primary key. Each Order
Number may have up to four part numbers included on it. In order for these
part numbers to be included on one Order Number, they must have similar
properties and processes to be completed. Similar, but not identical. What
happens is, these different part numbers get split from the original Order
Number and processed separately. I'm designing a form that will avoid order
entry errors that occur in when process data is updated at each stage of the
operation. To do this, it makes sense to refer to the original data on the
Order Number via a combo box... EXCEPT that the original order number has up
to four different part numbers associated with it. John Spencer came up with
a beauty of a query that splits up the Order Entry table into however many
part numbers are included with it. I was hoping to use this query as the row
source for my combo box on the form, but the more I think about it, the more
I'm convinced that this query lacks the reference information to specify a
row of information under the Order Number. (It keeps selecting the first
one.) I need some kind of unique identifyer for the row. All of the methods
I can think of involve appending to (or creating) a table and assigning
reference information there. I can do that. I just wonder if this method is
a little ass-backwards. If I'm going to create a normalized version of the
table (even if its limited) it seems silly to continue working around the old
version. I guess my question is: Do you know of anything that will make my
form act like I want it to, without having to resort to complete
normalization of the Order Entry table?
--
Why are you asking me? I dont know what Im doing!

Jaybird


Jeff Boyce said:
Just a hunch, but it looks like your [Order Entry] table has multiple
repeating "quantity" fields. While this might be the only way to handle
your data if you were using a spreadsheet, Access is a relational database.
You will not get the best use of Access' features and functions if you don't
normalize your data, and you will have to come up with complex work-arounds
to do "simple" things ... (oops, that's what you've just described!).

Tell us a bit more about your underlying data, not about how you are trying
to query it. In your world, what's the relationship among Customers
(?"Contacts"?), Orders, and Order Details? Not how you've structured your
current tables, but something in English like:
One Customer can have multiple Orders
One Order can have multiple Order Details
No Order is for more than one Customer

A more traditional (relational) database structure for orders can be found
in the Northwind database sample that comes with Access. Something like:

tblCustomer
CustomerID
...

tblOrder
OrderID
CustomerID
OrderDate
...

trelOrderDetail
OrderDetailID
OrderID
ItemID
Quantity
...

--
Good luck & Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Durn... Thought I had it covered... Anyhow, here's the SQL:

SELECT [Order Number], CompanyName, SpecID, Alloy, [Thick], [Part Number],
[Qty]
FROM [SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 1] as [Thick],
[Order Entry].[Part Number1] as [Part Number], [Order Entry].[QTY 1] as
[Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number1]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 2] as [Thick],
[Order Entry].[Part Number 2] as [Part Number], [Order Entry].[QTY2] as
[Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 2]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 3] as [Thick],
[Order Entry].[Part Number 3] as [Part Number], [Order Entry].[QTY 3] as
[Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number 3]) Is Not Null))
UNION

SELECT [Order Entry].[Order Number], Contacts.CompanyName, [Order
Entry].SpecID, [Order Entry].Alloy, [Order Entry].[Thick 4] as [Thick],
[Order Entry].[Part Number4] as [Part Number], [Order Entry].[QTY4] as
[Qty]
FROM Contacts INNER JOIN [Order Entry] ON Contacts.ContactID=[Order
Entry].ContactID
WHERE ((([Order Entry].[Order Number]) Is Not Null) and (([Order
Entry].[Part Number4]) Is Not Null))
ORDER BY [Order Entry].[Order Number]]. AS [%$##@_Alias]
WHERE [Order Number] is Not Null;

--
Why are you asking me? I dont know what Im doing!

Jaybird


:

Consider posting the SQL statement of your UNION query...

Tough to diagnose if we can't see what you see...


--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

I'm looking for a way to select a specific result of a Union Query as
a
row
source for a combo box. Currently, I cannot specify the exact result
I
want
because, I'm guessing, they are derived from a single record in a
table.
Is
there a way around this? I've tried using the Union Query as a
subquery
in
the row source property, but came up with the same results. Is there
any
way
to do this without creating a new table?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top