I need information in access table

Hi,

I am new to this Forum.

Please help me in the below requirements.

I need VBA for below mentioned details.

• Access Database to hold Requisition Data
o Table to hold file information
o Table to count number of records in each file
o Table to read First available date and show fiscal week
o Table to read Queries done by Bangalore team
• Form in access so users can mark when work is completed.
• Status report for Bangalore and US leadership – MS Access
• Query report for Bangalore and US leadership – MS Access


Sr.No File Name Date modified Divisions No of Lots Received No of Door Busters lots Received No of Big Buys Lots Received Total Lots Assigned
1 4 0
2 4 0
3 4 0
4 4 0
5 4 0
6 2 0
7 8 0
8 3 0
9 7 0
10 7 0
11 8 0
12 7 0
13 0 0
14 3 0
15 1 0
16 1 0
17 8 0
18 8 0
19 1 0
20 1 0