Hi - is this what you are looking for..?
SELECT [EENames].[EEID], [EENames].[LastName], [EENames].[FirstName],
[EENames].[DateEntered] FROM EENames;
Nick 'The Database Guy' wrote:
Quote:
Can you give more detail, the sql from the query would be helpful.
>
Might have something to do with the SELECT, SELECT DISTINCT , or SELECT
DISTINCTROW part of the query, or the grouping but without more detail
I cannot tell, I doubt that anyone else can either.
>
Good luck
>
Nick
>
>
Col wrote:
Quote:
Just wanted to add that if I change the combo box back to 3 columns, it
works fine.
Col wrote:
Quote:
Hi - I'm using Access 2000. I have a combo box with 4 columns based on
a query with 4 columns. The query has 111 records. The combo box will
only display 11. When I had 3 columns, it displayed all records. When I
added the 4th column, it initially displayed 17 records. I made a
change to the query, and now it only shows 10 of the records. I've
compacted and repaired without any change. I tried recreating the combo
box using the wizard, and I'm now back to 17 records...
>
Any suggestions?
