Friday, February 24, 2012

help with loop to find Dates

Hey all, I have this query that finds the 'next date' after a user inputs a date (and a another value). It works fine, except it only returns ONE row for the Date. Several dates have many rows, and I guess I need to have this loop somehow so it will return all rows? make sense? Can anyone help me with this?

SELECT top 1 Hours.Datewrk, Employee.Lastname, Employee.Firstname, Employee.EmployNo, Hours.Hourswrk, Hours.typewrk, Hours.formwrk, Hours.class, Hours.brate, PurchaseOrder.Descr, PurchaseOrder.Purchord, Hours.TicketNo
FROM Hours As Hours INNER JOIN PurchaseOrder As PurchaseOrder ON Hours.Purchord = PurchaseOrder.Purchord INNER JOIN Employee As Employee ON Hours.EmployNo = Employee.EmployNo
WHERE Hours.Datewrk is not null and Hours.Datewrk > '" & txtDate1.Text & "' And PurchaseOrder.JobNo = '" & cboJobNo1.Value & "'
ORDER BY Employee.Lastname, Employee.Firstnameremove top 1

No comments:

Post a Comment