Does not work on page

I can test it in query builder but when i preview the page and go to do the search i get nothing

Here is my statement

SELECT Employees.Last_Name, Employees.First_Name, Job_Transaction.Name, Seq_Descript.Seq_Description
FROM Call_List INNER JOIN
Call_Group ON Call_List.Group_ID = Call_Group.Group_ID AND Call_List.Group_ID = Call_Group.Group_ID INNER JOIN
Employees ON Call_List.Clock = Employees.Clock INNER JOIN
Job_Transaction ON Call_Group.Group_ID = Job_Transaction.Group_ID INNER JOIN
Seq_Descript ON Call_List.Sequence = Seq_Descript.Sequence
WHERE (Call_List.Clock = @.Clock)

Mike

Themlruts:

I can test it in query builder but when i preview the page and go to do the search i get nothing

You mean that you run this in query builder and get data but when you use it in a page you get nothing? Then (a) you're using different values of @.clock or (b) your page is pointing to a different database or (c) there is something wrong with your display (maybe you aren't binding the control to the data source)

|||

Its weird it should be binding fine. When i choose control i select the from the drop down box the input text field.

I dont understand

Mike

sql