Recent content by lwallis

JHB, 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! Lynda

Here is a scaled back version of my DB

Hi JHB, 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 Example: Branch 1 Employee overhead cost...........15,000.00...

Here it is! Thank you once again!!

I will post it as soon as I can... Thank you JHB you have saved me on this project before!

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...

Is this even possible?

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... Private Sub...

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...

I uploaded it again, hopefully this works... I don't think I mentioned it but the problem occurs when I try to edit a record. Thank you Lynda

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 Lynda

Thank you!!!! Once again you solved my issue!

Here is a scaled back version of the db.. thank you for your help! L:)

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...