Search command

  • Thread starter Teddy via AccessMonster.com
  • Start date
T

Teddy via AccessMonster.com

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.
 
M

Michel Walsh

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
 
J

John W. Vinson

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!!!
Click to expand...


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.
 
Top