Hi, Pls, anyone can help to me? I want to create search command for staff attendance. E.g Department name = SALES Staff name = KELVIN Start attend date = 1\08\2008 Last attend date = 15\08\2008 Then click search command button!!! I am really apprecite your helpfulness. Regards, Teddy. -- Message posted via http://www.accessmonster.com
Create a new query. Bring the Department name field in the grid, supply SALES as criteria. Bring the Staff Name field in the grid, add KELVIN as criteria. Bring the attendance Date field TWICE in the grid. Under one column, type >= #1/8/2008# and under the other one, type < #16/8/2008# Vanderghast, Access MVP "Teddy via AccessMonster.com" <u45321@uwe> wrote in message news:88d750d79b33e@uwe... > Hi, > Pls, anyone can help to me? I want to create search command for > staff > attendance. > E.g Department name = SALES > Staff name = KELVIN > Start attend date = 1\08\2008 > Last attend date = 15\08\2008 > > Then click search command button!!! > > I am really apprecite your helpfulness. > > Regards, > Teddy. > > -- > Message posted via http://www.accessmonster.com >
On Mon, 18 Aug 2008 06:23:01 GMT, "Teddy via AccessMonster.com" <u45321@uwe> wrote: >Hi, > Pls, anyone can help to me? I want to create search command for staff >attendance. >E.g Department name = SALES > Staff name = KELVIN > Start attend date = 1\08\2008 > Last attend date = 15\08\2008 > >Then click search command button!!! It would help us a bit if you were to tell us the structure of your table, the datatypes of the fields (are the backward slashes in the dates actual examples of your data?), and what it is that you want to search for. -- John W. Vinson [MVP]
