Adding All to an SQL Statement

[cranebill]

Hi. I am writing a job costing project in access and am having a little trouble. I have a combo box with this as its source:

SELECT DISTINCT Hoist.Manufacturer FROM Hoist ORDER BY Hoist.Manufacturer;

How can I add the "all" to this so I can have a future recordset select all hoists instead of just the manufacturer selected in this combo box?

Bill

 

[FancyPrairie]

Here's one example:

SELECT DISTINCT Hoist.Manufacturer FROM Hoist Union "(All)" from Hoist ORDER BY Hoist.Manufacturer;

 

[FancyPrairie]

Ooops! I pressed submit before I review the code. It should be

SELECT DISTINCT Hoist.Manufacturer FROM Hoist Union Select "(All)" from Hoist ORDER BY Hoist.Manufacturer;

 

[cranebill]

In doing this will the "(All)" act as the "*" to generate a full list?

Bill

 

[DaltonVB]

are you looking for all of the fields or all of the records from [Hoist]

 

[cranebill]

Records. This is so I can get a full list instead of just the one manufatcturer from the combo box.