Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Jsha

  1. Jsha

    Freelance Pricing?

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

    Freelance Pricing?

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

    IIF Statement Not Working

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

    IIF Statement Not Working

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

    Using VBA for complex calculation

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

    Using VBA for complex calculation

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

    Using VBA for complex calculation

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

    Criteria calculation performed in Header

    Thank you
  9. Jsha

    Criteria calculation performed in Header

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

    Criteria calculation performed in Header

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

    Criteria calculation performed in Header

    Dhook, I tried that but I am getting an Error. Is there a way I can group the totals in the header though?
  12. Jsha

    Criteria calculation performed in Header

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

    Dynamic Report using Crosstab Query

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

    Calculating partial data in a report

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

    Calculating partial data in a 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...
See more

Part and Inventory Search

Back
Top