Dear Friends,

I am facing a deep trouble at the end of a road. In a Hotel Management software one report is not working instead showing some unusual errors.
I have explained here the whole thing.

I have used MSACCESS as back end database. In the database there is table usage wherein users logged in time in the software is noted.The structure is as such.

User Id: Text field
Date: Date
Entrytime: Date/Time
Exittime: Date/Time

Using this table i need to produce a report showing user id and entry,exit time group by date that is selected by the user on his choice. That is each user will select dates from a Calendar Control and then click a button to show it.

Now using DataEnvironment i have designed the data source, but the problem how will input the criteria for the date to the DataEnvironment at run time.

I have selected the table then group it under the group tab as date. I am just wondering how to select the date but then there's no idea flowing till now.

Pl. help. Your effort will always be highly regarded as this is my first commercial project and i need to deliver it in time. I will also appreciate if anyone cities me some important tutorials on Data Environment ( I have cheked down MSDN's but couldn't find anything interesting).

Regards to you all,

Hrishikesh