Weird Database problem

[krillin]

I have a combobox on a form wich uses a Query and returns only names wich matches to a string "DIV/RT/223", it returns almost all names but skips a few. I have looked in the database but i can't find any reason why i should skip these records.

Anybody??

 

[AncientOne]

have you got leading spaces or embedded spaces in the strings that don't match?

 

[krillin]

Nope, nothing. I checked and double checked.

Isn't this weird or what!

 

[AncientOne]

No, it's not weird, we just don't understand what's happening yet!.

1) what's the SQL for your query?
1A) What is the bound column of the combo?

2) What happens if you run a straight query on these records, ie don't use the combo?

 

[Rich]

Try , Trim([YourField]) then use the criteria

 

[krillin]

Bound Column = 1 using this string

SELECT Contacts.[Display name], Contacts.Department FROM Contacts INNER JOIN Storage ON Contacts.ID=Storage.ID WHERE (((Contacts.Department)="DIV2/RT/223")) ORDER BY Contacts.[Display name];

even if i use a straight query, it skips the same records (almost 450 records),

hmm that's not right

 

[AncientOne]

You have a join in your query. If there are not corresponding records in both tables, i.e. a storageID for every Contacts ID, some will be omitted.

 

[krillin]

Damn, i missed that. It works now, many thanks for your help