F1A1G1inDC
Board Regular
- Joined
- Jun 20, 2003
- Messages
- 74
Not sure how to best describe this...but I will give it my best shot.
I do a global headcount report on a monthly basis. Each region (USA, Canada, Asia, EMEA, etc) send me their headcounts for each region and business unit. Due to data-privacy laws, I only get basic info from EMEA (basically headcount). Is there a way that I could do a table/form/query/macro that would give each region (or me) a spot to enter things like Headcount, Country, Region, BU and have Access auto-populate the "detailed" information? Ultimately, what would work best would be for them to enter in (field to left of ":" and data to the right)
Region: EMEA
Country: Switzerland
BU: MDS
Headcount: 17
And then have the result be:
Region Country BU EmployeeID Headcount
EMEA Switzerland MDS EMEA1 1
EMEA Switzerland MDS EMEA2 1
EMEA Switzerland MDS EMEA3 1
etc, etc, etc
Any thoughts?
TIA,
F1A1G1
I do a global headcount report on a monthly basis. Each region (USA, Canada, Asia, EMEA, etc) send me their headcounts for each region and business unit. Due to data-privacy laws, I only get basic info from EMEA (basically headcount). Is there a way that I could do a table/form/query/macro that would give each region (or me) a spot to enter things like Headcount, Country, Region, BU and have Access auto-populate the "detailed" information? Ultimately, what would work best would be for them to enter in (field to left of ":" and data to the right)
Region: EMEA
Country: Switzerland
BU: MDS
Headcount: 17
And then have the result be:
Region Country BU EmployeeID Headcount
EMEA Switzerland MDS EMEA1 1
EMEA Switzerland MDS EMEA2 1
EMEA Switzerland MDS EMEA3 1
etc, etc, etc
Any thoughts?
TIA,
F1A1G1