Unanswered: Search for Records within a Date Interval (Query)
Hello Guys.... Good day... as we all await the release of BDB v 11 please take a look at my concern here. i have form that keeps data on products and the dates they were purchased plus who sold it to the customer. now im able to search for sales made by salespersons for the day and print them out. what i want to do now is to be able to write a query that will allow me select a date range say (1 Jan 2015 - 5 Jan 2015) and print all sales made within those days (time interval). i hav attached an example of what i mean.
Example.zip (attachment is by help of James Tubbrit; A file he sent in one of my posts "Daily Transaction")