Thank you, I tried searching but didn't see anything on it. I was unaware of this section of the website though, so thanks again for pointing me in the right direction.
Hello guys, I haven't posted in awhile and would like to thank all those that helped me get my brain working in my other threads. But onto the topic, if anyone does database creation on the side(freelance) could you possibly steer me in the right direction as far as pricing. I have a job that...
Thank you for the reply, but it is more related to the Phase than anything. When the hours are input, the user tells the database where to apply the hours. So, it would be 2 hours in Phase2 and 8 hours in Phase1, which would in turn give the employee 10hours for the day.
I have been trying to get this conditional calculation working in a query for the past couple days. I wanted to know if I am doing something wrong here and if so what?
The problem is this, if a person works 10 hours a day. 8 of those hours they were doing work for "Phase1" and the other 2...
I was more looking for some help with regards to getting this function to work in my Report. Here come a very noob question, but how do I call the function I wrote above. I am trying to show the results in an unbound text box.
Sorry, I should have stated this before, the formulas are in an unbound text box. I wanted to put the formulas in the query so that they would be controls in the report, but Access kept telling me the formula was too complex.
Okay, I have been looking for awhile on these forums to find my answer and I have found a few, but nothing on this particular subject. Maybe its because my skill level is to low.
I have a database tracking hours, type of work, and money. (brief description)
Okay, in the database some...
The problem is that I cant even get it to work in the page footer area, I am hoping that if I can at least get it to work there I can simple reference that txtbox in the header. It may not work though I am thinking because the information in the page header populates before the rest of the...
I must make a clarification, the details are not in the detail section of my report, I have created a FullName footer and I am doing a calculation of total hours there. I want to take the hours of everyone who has a specific job title and add them together. And that number should appear in...
I have a report that I am creating that needs to basically group a totals in the header. This is the last part that I need for this report to be complete and it is racking my brain.
Okay, the report basically looks like this.
(Header)
Activity General Location Hours...
I know this has been talked about in other threads, but none seemed to fit my situation, or maybe I just didn't know how to apply them to mine.
My database is an employee database tracking time, project worked on, and dates. (it tracks more but thats is all that is necessary for this...
Yes, I am getting the correct data. I thought about making seperate queries 1 for each category, but the problem i ran into was duplication of information in the detail section of my report.
Okay, I have been serching the forums for the past 2 days trying to find something similar but have not found it. I have a query that prompts the user for a project number and a date and pulls all of the employees working on that project and how many hours they worked that particular day.
So...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.