Date

[vjk1]

My job requires me to assign audit personnel to various business firms across a State.
The table which I have created in Access-97 has the following fields-
1.Audit_party_id
2.Name_of_concern
3.Starting_date_of_audit.
4.Finish_date_of audit

I have two problems to solve :-
1.Iwant to find out in advance the list of Audit_party_id,Name_of_concern and Finish_date_of_audit by inputing a range of Finish_date_of_audit as a parameter.
(For eg.List which finishes audit between 15/Dec/2001 and30/Dec/2001.

2.As there are a number of regional holidays in my country(INDIA) I would like to mark them in advance in a system calender and print them out while sending the advance audit program to the audit party personnel.

Can any body help?

 

[snoopy75]

I don't know about the second one, but the first one is pretty simple.

Create a query with the fields you want to see, and in the Criteria section under Finish_date_of_audit, put "Between [Enter Start of Date Range] And [Enter End of Date Range]". This will prompt your user for two dates, and then only return those records which are between those two dates. If you use this query as a source for a report, you can present the data in a nice, neat fashion.

--Ryan