check between date in two Cells Excell or Access 1

[movedown]

I have this big list (21327) with casenumbers.
Want i want to do is show on a date how many material is in stock.

example
casenum. prod.date remov. date
N234122 15-10-2002 22-11-2002
n435634 21-10-2002 29-10-2002

Is it possible to ask for 19-10-2002 and excel or access will show all material that is there.
So the case n234122 will be in the new list.

 

[doughahn]

you need to build a query out if the table where the data resides. in the "criteria" field below the "date" column type "[type in date]" for the query to ask you to type in a date. after a date has been typed in the query will show only records that contain that date. I hope this helps you,
Doug

 

[movedown]

Doughahn,

thanks for your reply, if have find out what to do after your reply.

in the "criteria" field below the "prod date" column i put
>= "[start date]"
in the "criteria" field below the "remov.date" column
<=&quot;[end date]&quot;
then i made a marco so the date only had to be typed in once.

Thanks again you put me on the right track.

maurice.