Casanova411
Registered User.
- Local time
- Today, 01:11
- Joined
- Jul 25, 2012
- Messages
- 15
I am currently trying to complete a Search Form for a table of mine and i baffled by what Access does for me. I want to Search for dates between Start Date and End Date when there is input and List all dates when blank. This to me is the correct code
Like "*" & (Between [Forms]![SearchRecords]![SearchADate1] And [Forms]![SearchRecords]![SearchADate2]) & "*" , which goes in the Criteria Row in the Query.
When i close the query Access replaces my code with this
Like "*" & (([EquipmentAssignments].[Assigned]) Between [Forms]![SearchRecords]![SearchADate1] And [Forms]![SearchRecords]![SearchADate2]) & "*"
, which returns the wrong data regardless of output. No matter how many times i erase the code Access replaces mine with it wont budge. Can you guys tell me what is going wrong? and provide a solution.
Thanks ahead!
Like "*" & (Between [Forms]![SearchRecords]![SearchADate1] And [Forms]![SearchRecords]![SearchADate2]) & "*" , which goes in the Criteria Row in the Query.
When i close the query Access replaces my code with this
Like "*" & (([EquipmentAssignments].[Assigned]) Between [Forms]![SearchRecords]![SearchADate1] And [Forms]![SearchRecords]![SearchADate2]) & "*"
, which returns the wrong data regardless of output. No matter how many times i erase the code Access replaces mine with it wont budge. Can you guys tell me what is going wrong? and provide a solution.
Thanks ahead!