Week Input form

[Kevin Labore]

Hi

I am sure there is a fairly simple solution for this but I am trying to
create an input form where I can input the entire week at once. I want to
be able to input Figures for Sun thru Sat. for about 55 or so figures for
various Dept Categories. So basically I want to display a Grid approx 7
Cols(DOW) by 55 rows(depts).
Also I want to access active depts only for inputting

Would Creating a query be the best way to do this?

I would be accessing 3 tables for this:
dept ( deptID,Deptnum, Deptdesc,Status (dept active or not))
deptdate(deptdateID, deptDate)
Deptsalesdetail(deptsalesID,deptrecID, deptnum, deptsales, deptqty)

Deptsales = $ in sales
deptqty = units sold

some guidance would be appreciated or an example.

Thanks

Kevin