Create Monthly Table Based On Employee List
Greetings all!!!
I have a database containing a table of employees and their rank. I want to record monthly details regarding these people: hours, performance, etc. Their rank can change dynamically from month to month. They may be a Supervisor for a month, and I want to change this value on a monthly basis. But I want to generate a Table which shows all employees belonging to each of the eight departments, but which has empty fields enabling me to record these monthly values. I then want to be able to pull up that data at any time to see these values for any given month in the past. I also want to add the values of each field and total them for the various departments providing monthly and yearly values on a departmental and organizational (grand total) level.
The employee names and their respective departments rarely change. I don't want to have to select their names (about 125 of them) every month to create a new blank form in which to put the monthly data. I want to have perhaps a button which creates the records and puts the names in for (1) department, (2) year, and (3) month, but that adds the fixed fields ready to put the data in. This data is required every month and the field names will never change. I'm sure the solution is programmatically simple, but I seem to have a mental block over the issue.
I hope that someone casts some light on this.
Do I use a Create Table query? (The data can remain in one table.) I would like to do it programmatically. My VB is pretty good, but, it seems, not good enough.
:confused:
View Complete Forum Thread with Replies
Related Forum Messages:
Create A Randomise List From A Table And Save The List For Each Month
Hi All a newbie here so any help will be appreciated, sorry for the long post but trying to give you all the information you might need. I wrote a basic access database for my Church to aid in a paperwork audit for a charity food drop which we do monthly to give free food to the needy. But each month it gets harder to find out who was in line first so I thought with all your help we may be able to randomize the names each month in a different order as to avoid confusion and also avoid people waiting in line as they turn up at 5am and we don't start until 9am. So if this will work in access they can all come for 9am I don't mind creating a new database and adding the additional information, if that's what it would take. My Background I have created basic databases from scratch not using wizards, But I don't know much about code or how to implement it so any help in where code goes it would be very much appreciated. Database details (Microsoft Access 2002 version) Table Name = details Field name = ID (auto-generated) Field name = FirstName (text) Field name = Surname (text) If possible it would be nice to keep a record of the randomized lists (in the database somewhere ?) each month in case anyone wants to see it or disputes the lists, where I can just create a report to show the details. There will be approximately 90 to 125 names. Thank you in advance for all your help in this matter Britgent
View Replies !
How Do I Create Monthly Fees?
I have stuck in something and i hope someone will help me with this: I have created a DB which shows all the students of a musical school. Each student pays a monthly fee (sep-june, 10 payments per year). I dont want to create all these columns in my main table beacause it will be too crowded. The only thing I can think of is to create 10 different tables one for each month but i think it won't work well when I want to see how much a specific student pays.. any ideas? the information for each month that i want to have is the student first and last name, date of payment, level, fees amount and money paid (and perhaps month name..). Thank you in advance guys!
View Replies !
How Can A Create A Monthly Query ?
Hi guys, Can someone please tell me if there is any way to create a query that gives me ... lets say a sum of smth monthly. I'd like to create a crosstab query to have at rows : names columns : months values : sum of smth (kilometers for drivers) Thankyou in advance
View Replies !
Based On This Checksheet How To Create A Table?
Below is my attachment file. ٱ - checkbox spec 1 is not a record. when u are adding a new checklist, the format should be like that. But i duNNo how to create table based on this. tablename -create -view -update -no update -remarks but for spec 1 do i need to create another table?
View Replies !
Create A Table Based On 2 Tables With Different Fields
Hello, I have attached a zipped excel workbook to best describe what I'm trying to do. I have table1 and table2 and I'm trying to write a query in access to get the output as shown in the workbook. I'm having hard time getting this right. I would appreciate your help if possible. Tks Richard
View Replies !
Create An Entry In A Table Based On Records Matching
Where a many to many relationships is resolved with a linking table...Is it possible to create an entry in the linking table where the two linked tables have the same value e.g. create a entry in the linking table where client table has same value as a job profile table i.e. both are in insurance. Therefore want to create an entry in the middle table with foreign keys from either link automatically ta
View Replies !
Verify Imported Field Based On List In Table
Hi, I'm not sure if this is possible, but I've heard you guys really know your stuff. I have a client who would like to import a list of e-mail addresses, but would like to verify the domain name used in the provided address against a list of domain names pre-populated in a table. Do I need to use Dlookup? Here are some additional details. Thanks in advance! MAIN_IMPORT_TBL ID FNAME LNAME E-MAIL PHONE DOMAIN_TBL DOMAIN_ID DOMAIN_NAME AP
View Replies !
Employee Expenses Table Design
Hi, I'm having problems getting my head around the best way to design a table for an employees expenses. This is my current M_Expenses table: ExpenseID (PK) PayrateID ExpenseType Amount PayrateID is the foreign key to a table that holds information about their rates, evertime etc. My idea was that the user would only choose an expense if the employee were entitled to that expense - so if someone was not entitled to flight expenses the record would not be created. However my boss says that if he were to look at the report produced from this he wouldn't know whether the person putting in the data just didn't have the information at the time or it didn't apply to that employee. So I will need to let the users know that they must create a record for each. Also the report must list all of the expenses: Per diem expense Accommodation Car hire Flight Other expenses They need to be listed in this order and must appear whether that particular employee is entitled to them or not. I don't see how I can do this as it is because my subreport that lists the expenses is a continuous form and they are not listed in alphabetical order. Plus only expenses that the user has chosen will appear. The only other way I can see to do it is redesign my table as follows: ExpenseID PerDiem Accommodation CarHire Flights OtherExpenseType OtherExpenseAmount But that doesn't seem like good design?
View Replies !
How To Create A Price List
Hi all, Before I start, please know that I am what you call a newbie to a certain extent even though I created in the last 3 years a very complex and efficient database for my business. This is going to be hard to explain, but I'll try. The time came to stop creating the Price List in Excel and copy and paste in Access.(mainly to make it easy for other person to maintain and understand) I know more or less the tables that will need to be created. My problem is how to store calculated fields in a table (I know I really shouldn't, but how else can I accomplish this), since all the costs and selling prices are the result of complex formulas. If this information is not enough to understand my question please let me know. Thank you for any help. Emilio
View Replies !
Query2 Tables To Create One List?!?
I have a db which enables users to enter expenses. tblExpense tblExpenseDet tbleExpenseMileage tblExpenseDet & tblExpenseMileage are joined to tblExpense As the expenses are entered at User Level not Client Level, I need to extract the Client ID from the 2 sub tables to create a list grouped by client so we can report the billable expenses. I'm thinking union query but wouldnt know where to start. Any help would be appreciated Ta
View Replies !
Msg Box Based On List Box Selection
I have a form that contains a list box with 11 separate options. Within this list is the option named "None". My desire is to have a message box displayed when any option is selected other than "None". I have searched various threads, however I have been unsucessful nailing down my issue. Thanks in advance for the assistance.
View Replies !
Create Multiple Records Based On Date Range
I have developed a Debt Management program for work but I am stuck on a feature that we need to add to it. Basically I have a table which holds "planned future transactions". These are ad hoc transactions that need to be added from time to time to the clients budget. For example the client might have $500 a quarter for school fees for the next two years or he might receive a bonus every six months for the next 5 years. Currently we are putting these in manually but it is tedious and is causing complaints. The feature I require is to be able to add a record such as the school fees, nominate that this fee is paid every three months for the next 8 quarters and get the system, say through an append query? to create 8 records, each with the appropriate date 3 months after the previous one. Any suggestions or assistance would be appreciated. Thankyou
View Replies !
Can You Create New Column In A Query Based Off Of Data From Two Columns Already There
I will need to create a new column in a query with data based off of two columns currently in my DB. Current fields are: [TestType] & [TestReason]. New TEMP field will be [TestCombo] TestType has 4 possible option via drop down. TestReason has 21 possible options via drop down. TestCombo will be one of 10 options depending on the data in TestType & TestReason. examples: (here is an example of how the combo field will be populated. There will be ten total rules like this. one for each possible text option in the combo box.) If [TestType] is "DRUG" & [TestReason] is "PRE" or "RAND" or "PA" then [TestCombo] would be "DOTDT". If [TestType] is "ALCOHOL" & [TestReason] is "PRE" or "RAND" or "PA" then [TestCombo] would be "DOTAT". If [TestType] is "DRUG" & [TestReason] is "N-PRE" or "N-OTHER" or "N-FUP" then [TestCombo] would be "NDDT". The data does not need to be saved anywhere at all in the database, just generated when pulling this query. It will then be exported and dumped into another system. Thanks. Here is a temp copy of the database with some junk data to maybe make it a little more clear.
View Replies !
Create A New Record, Opening A Form Based On The Key Field
I seem to need some help! I have a table with customer information in it ie: name, vehicle, (Key=Id number)... it is the master link to the repair table ie: mileage, (Key=ROnumber), and repair data.. these two work together beautifull now I need to add another table, a check sheet for checking over a vehicle. I create the table and the form however I cannot open a new form with the ROnumber from the second already open form into the newly open form. (the second form is based on a Query, and I have tried changing it to a SQL statement both with no luck) is there an example of what I need to be doing to link the ROnumber to the ROnumber in the new form, or create the ROnumber so it will add the data in the linked table? I need this to open using a button on the open repair form David
View Replies !
Create Checkboxes During Form Open Based On Query
I am working on a database that tracks products. The products are divided into groups (Bath Salt, Stick Incense, Candle, etc.) and these are store in a table. The products themselves are stored in another table. When a new scent is created, it can belong to multiple groups ... for instance, Strwberry Vanilla could be a perfume, a bath salt, a candle, stick incense. When the form is opened, I want to read the contents of the groups table and create a check box for each entry. I do not really want to use a list/combo box for this task ... would prefer to be able to check in a list of boxes to specify what groups to create entries for when a new product is entered. Thanks Phil
View Replies !
|
TRACKER
