Thanks! The code didn't do exactly what I needed, but it led me in the right direction. Basicaly I have the company table with the companyNum in one column and authorized in the other.
I'm able to get the % of people assigned to each "Department " by doing a query on the first character of the companyNum. I then do a SUM of the authorized for that department, and then do a count of the records in the query gives me how many...
piko1981
Last Activity: Mar 28 '07, 08:22 PM
Joined: Mar 5 '07
Location:
-
Close, very close. Another question though. Wouldn't it make sense to leave the Authorized/Assigned field in the company table? I see what this query does, and it helps a lot, but this way would require an employee being assigned to a companyNum for it to have an Authorized/Assigned value correct? I still need an Authorized value for compayNum(s) that don't have anyone assigned to them. Also, by Authorized/Assigned do you mean Authorized? It displays...Leave a comment:
-
I also have anoth post..... question about a table which further descrbies why I have the authorized and assigned numbers all in the same table, please read that one as well. Thanks,
PikoLeave a comment:
-
I've only done the code for Alpha and Charlie so far just for testing purposes, the final would have HHSB, A, B, CLeave a comment:
-
I know storing totals isn't the best way to do things.... but if all else fails I will explain the situation better to try and emphasize what I'm doing....
Here's the code for when you click on the companyNum combobox
Private Sub companyNum_Ente r()
Dim subtractAssign As String
subtractAssign = Left(companyNum , 1)
Select Case subtractAssign
Case "A"
Alpha_Assigned...Leave a comment:
-
Form update
Using Access 2003 and Windows XP
The form displays data about an employee (Their SSN, Name, etc). It also displays what company that employee belongs to in a combobox (Ex A204-04,C204-04), along with how many people are assigned to the company (Assigned to A204-04, Assigned to C204-04)
For example purposes, employees 1,2, and 3 are assigned to companyNum A204-04. If in the first record (Employee 1), I change the company... -
Question about a Table
I'm using Access 2003 (Windows XP), and I'm trying to determine if I need to break a table down farther
There are two tables directly related, Employee, and Company. Employee has a SSN, lName, fName, MI, and companyNum. Every Employee has one companyNum they belong to, and one companyNum can have many employees so it's a one-to-many relationship.
The company table has the unique companyNum, as well as 10 columns. The...
No activity results to display
Leave a comment: