I would like to make a query from
transactions to see the patron history by enter a barcode.
I have made a recordset to get the patron barcode
in the same time to get the Id field from patrons
as this value is connected to the [checked out to] field in the transaction.
I have tried
- str = "SELECT [ID], [BookID], [Checked in date], [Checked Out Date], [DueDate] FROM Transactions ORDER BY [duedate] Where [checked out to] = " & _
-
rspatrons![ID]
-
-
-
Me.result_list.AddItem "ID; Title; Checked in date; checked out date ; due date "
-
Me.result_list.RowSource = str
my result_list is a value list type
and it displays
ID book id checked in date checked outdate due date
in the first line without my search results.
did i miss anything ?
thanks.