i have this code:
SELECT [Transaction].[TransactionID], [Transaction].[EmployeeID], [Transaction].[TimeIn], [Transaction].[TimeOut] FROM [Transaction] WHERE ((([Transaction].[Barcode])=[Forms]![DTR]![TxtCode]));
i just want to add more filter like, Select ..... Where [Transaction].[Barcode]= .... AND [Transaction].[Date]=..));
i just want to add the "AND Transaction.Date to the above code to add more filter to the result, i just don't know how and where to add. Please help.. thanks!