Search results

Besides the typo -- IFF should be IIF... your structure is not normalized. There are repeating groups in the table, and that causes you the headache. Correct your structure and your problem will be solved. Search on Normalization and do some reading on the subject. Here are some links that...

In your first query, remove the "AS Expr1"... no need for it.

Is the form's Visible property set to False? Is it set to False via Code in one of the events? Is there a code that cancels the opening of the form if a condition is met (or not met)? Can you open the form in design mode?

Hi, Is there a code behind any of the form's events (as in Open, Load, Current, etc.)?

Hi, You second should be: SELECT DISTINCT tblProspects.CompanyName , tblNotes.NoteID , tblNotes.Note , tblNotes.NoteDate FROM (tblProspects INNER JOIN tblNotes ON tblProspects.ProspectID = tblNotes.ProspectID) INNER JOIN qryNotes ON (tblNotes.NoteDate =...