Thank you so much for all your help.
I'm not a programmer, just someone that had a tiny bit of DB knowledge from 15 years ago so I got elected!
I would still be stuck on form creation without your help.
Thank you again!
I'm sorry I'm singling you out but you seem to be the reliable source that has always given me a correct solution.. I'm on the home stretch of this project and I hope this is my last issue. Would you mind looking in the Reports Forum at a post I made titled: "Subform Only Showing...
I have one query that the main form is based on and another query the subform is based on.
I linked the subform to the main form by a common field "Branch"
My main form displays Grouped Employee overhead totals based on Branch
Branch 1 Employee overhead cost...........15,000.00...
Maybe I'm going about this the wrong way.... I have created a query that incremintally adds the percent utilized for each employee. so the last line in the query for each employee has the total percent.
Can I update a field in the employee table called "utilized" based on the last line for...
Where would I insert the code to see the finished SQL? I apologize for this code. I have looked a videos and examples on the internet so it's a mix of things I have figured out over the last month. The is my one and only attempt at creating a database. Thanks for any help...
Add textbox to show Max subtotal???
See PDF example...
How can I get Employee Billy Johnson to show on one line with a total of 1.25? (0.5 + 0.75 = 1.25)
I need to merge the two lines and only show something like this:
Division Manager Billy Johnson $44,174.60 1.25
I don't know if this...
Can anyone figure out why I am getting this error? I have attached a piece of my DB to this post.
I compared it to other like forms but I am not experienced enough to figure this out..
Thank you for your help
The first report example is what I get when I start on the main form and select an organization, run the report, opens report - BIG SPACE between the details and my footer section which holds a subform.
The second report is what I need it to look like, what's strange to me is I get the report...
It is the same. It is a combo box selection the user chooses and the ID is stored in the employee table.
Here is another piece to the puzzle: The records that work have the Division Manager listed first so it appears that the iif statement is only looking at the first record for each branch...
My report is run from the main form: The user selects a branch and clicks a button that runs the report for the branch that was selected.
The report contains employee cost information and the employee's role.
In the header section of the report I created a text box with the following...
I have attached my DB in Access 2010. I don't have 2003.
Here are the forms and respective subforms:
frmBranch sub is subEmp
frmCourseExp is subCourseExp
frmEXP_CAT is subExpDet
They are not pretty because I'm trying to figure out stuff.
All parent form fields have BranchID in them. I...