the example ,
assume we have two tables as below :
tbldirectorates
application number
directorate
department
section
tblapplication
application number
date
number of computers
number of printers
now, if i want to display information in the report depand
on two these tables then i should use a query to get information with following fields "application number","directorate","number of computers" and "number of printers"....isn't it ?
but i don't want to display all the information in these tables .....!
what i mean is i want the user to enter name of a directorate and a period of time for example
directorate : information thecnology
date : 12/4/2004 to 12/8/2004
to get the "application number" "number of computers" "number of printers" for the specified directorate and the date that have been mentioned above.
what i think is i should (by using a query)enter one criteria to enter the directorate (information thecnology) and two other criteia to enter the date
first one :12/4/2004
second one :12/8/2004
but i don't know how to do it .
i hope you get it....!