Ok, i have managed to make it work by formatting the date returned from the user interface in this format dd/mm/yyyy, which has worked only that some records are left out because in access the date field has time attached to it. so i was wondering how i can get rid of the time element in the date from the database.
i am using access as the database