timeintervall query

[Traden]

Hi out there,

i do have a form with 2 textboxes, in this textboxes you can enter dates, a start date and a end date. I want access to look up only the records that are in between that dates, here is my SQL Statement:
SELECT [Material Issue].[Quantity], [Inventory Control].[Description], [Inventory Control].[Lot], [Material Issue].[Location Code], [Material Issue].[Issue Date]
FROM [Material Issue] INNER JOIN [Inventory Control] ON [Material Issue].[ID]=[Inventory Control].[ID]
WHERE ((([Forms]![queryTimeintervallIssue]![tbStartdate])>=[Material Issue]![Issue Date]) AND (([Forms]![queryTimeintervallIssue]![tbEnddate])<=[Material Issue]![Issue Date]));

i do not know why that doen"t work, any one a idea?

thanks

Traden

 

[DJN]

What results, if any are you getting?

 

[DJN]

If you are getting your start date and end date from text boxes on a form then use between Forms!FormName!txtStartDateTextBoxName and Forms!FormName!txtEndDateTextBoxName as the criteria or the Issue Date field.


David

 

[Traden]

hi, i do get no results on that query, and i get my dates from textboxes.