Weekly input

K

Kevin Labore

I am trying to figure out how to go about this --- the result that I want is:

Columns across top: (Sun - Sat)
Rows (Containing DeptSales $ & DeptSales QTY (units) for Which depts are active)

Each form entry would be for the week.

I am thinking maybe a Form/Subform with a query?

The form would be the weekending date
The Subform would be the entry screen
Query - Crosstab with DOW's on Columns and Dept or rows

I have 2 entries per dept# per day (sales $, and Sale Units)

I have 3 tables which contains DeptSalesDetail (deptdateID,deptnum deptsales, deptsalesqty)
Dept (Deptnum, deptdesc,deptstatus(active or not))
DeptDate (deptdateID, deptdate(date of sales)

can someone offer suggestion or examples of how to go about this

Thanks

Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Week Input form 0
Crosstab query challenge 0
Input form by week 0
CrossTab report "super" columns 5
Excel type spread sheet for recurring monthly items 0
Dept/Month/Year Crosstab problem 0
variable subform values 1
Complex Form Design 3

Top