Adding an 'All' option to combo box

I have searched for a while on how to do this. The solution usually given involving the UNION command does not help me as I'm only reading in one table.

I don't want to produce a list instead as the list is always changing.

I'm reading tables from a 3rd party flexitime system database into a Access database. I have set up a combo box to list all of the employees clock numbers. This, in turn can produce a flexisheet for a chosen month. We would like the option to display or print details for all of the employees at once.

Here is the RowSource command

SELECT Employees.[Clock no] FROM Employees ORDER BY Employees.[Clock no];

Does anybody have any idea?

Originally Posted by pedxxx

I have searched for a while on how to do this. The solution usually given involving the UNION command does not help me as I'm only reading in one table.

I don't want to produce a list instead as the list is always changing.

I'm reading tables from a 3rd party flexitime system database into a Access database. I have set up a combo box to list all of the employees clock numbers. This, in turn can produce a flexisheet for a chosen month. We would like the option to display or print details for all of the employees at once.

Here is the RowSource command

SELECT Employees.[Clock no] FROM Employees ORDER BY Employees.[Clock no];

Does anybody have any idea?

See if this link is your solution:
http://www.mvps.org/access/forms/frm0043.htm

No sorry. This is the fix I mentioned above. Unless you know better, this is a union of two or more fields. I'm just trying to add "all" to one field.

Any more ideas?

"pedxxx" wrote in message
news

I have searched for a while on how to do this. The solution usually
given involving the UNION command does not help me as I'm only reading
in one table.
Read the instructions again. They assume that you're using *one* table,
just as you are!

You can UNION with a SELECT statement which returns a single record
containing only calculated fields - one of which is "ALL".

John W. Vinson/MVP