Search results

Thanks Pat for your help. I am truly beaten.... Access wins! I have been working on this on and off for a couple of days now. I did get the 9 problem resolved, but now the rolling twelve month criteria in the other query is no longer working. All records are pulled in and totaled instead of...

Thanks Pat for your response. I have two joined queries. One query accumulates all the incidents by employee number. The second query pulls in the date and level of the last incident. When I used your suggestion of Max and <>9, all the employees that had a 9 were completely eliminated from...

I was reading several threads on First, Last, Min & Max Functions trying to find a way to enhance a report I have. The report I have works fine, except I have to do some manual research. The report is an attendance report where I track the number of times an employee is absent. When the...

Thanks for taking the time to respond. Currently I am working on another project and I am unable to get back to work on your recommendation. I really appreciate your help. Thanks,

I am trying to build a query that pulls in the last six weeks production information for each one of our employees. I have been using the beginning and ending date criteria, but in a lot of cases one week will have zero information or the employee has less than 8.00 hours, which in that case...

Thanks. I have been properly chastened. How do I go about changing my login name, so I can start over?

Have something strange happening in my report. Our employees had to work on New Years Day, 01/01/05, so all the that day's information is listed as Week # 05/53. I need it to be calculated with the whole week. I don't know how to fix it. Has anyone had this problem and could offer a...

Thanks for your reply. Sorry, I don't post very often so I am unsure of the rules. Mostly just read and research. I worked late on the problem yesterday and resolved the problem. I had to be able to use the report today, so I was under a tight timeframe, so I got a little panicky and got...

Referring to the thread submitted by robjones23, 1/4/05, I am have a similar problem with a report. I have a report that I pull data in that is entered on a daily basis and I convert total by week number. The report then pulls in the last six weeks for an average. The report worked fine...

Week Number I was having basically the same problem with my report except I need to pull the information by the last six weeks to arrive at a six weeks average. The data is entered daily and I needed the information by week, so I used Format([EntryDate],"ww/yy",2,2). When I request the...

Date Range PRoblem I didn't want to have a date as a text field. When I imported the spreadsheet it made all my fields text fields and when I tried to change them to a date field, I lost all the data in that field. I tried to get around that with the Make Table Query and format the text-form...

I am including the year in my criteria, for example I am asking for 04/01/04 through 04/26/04 and Access is giving me all years I have data, i.e. 04/01/00 through 04/26/00, 01, 02, 03. It is not limiting to my request of year 2004. I thought that I might have done something wrong when I...

In setting up a new database I had to import an Excel spreadsheet with all the information which consisted of several years of load status information. I had problems with the dates as they wanted to be text fields instead of date fields. I did a Make Table query converting the dates to the...

in the Standard Hours =sum[Standard Hours] in the Cumulative Total Cumulative Hours Value + Standard Hours Value

I have been working on this on and off for a week now. I can't seem to grasp what to do. I submited a question, but alas no response. In a form can you have an cumulative total? For example, I want to enter standard hours, then have a cumulative total, Every time the standards hours would...

If you post a question and you never receive a response, does that mean: (A) The answer is unknown (B) The person asking the question is banned from the forum unknowlingly. (C) The question was too dumb to be answered? Just was wondering. Lansel

I have created a form on which information on a trainee's performance is entered. I have to add a field in the form that calculates weeks worked. Each week the employee's standard hours are entered in the form. The next week when the standard hours are entered I want it to be added to the...

Thanks Bert. With your response, I was able to make the correction. I had previously included the "Else" statement, but I didn't end each section with "End If". Now it works. Thanks you very much. You helped make my day a lot shorter. lansel

I have a report that I am trying to display numbers in red if actual did not meet the guideline. I can't get just the outside the guidelines to be displayed in red. Even if the number meets the guideline, it is printed in red. If Me.[2nd Week Eff] < 0.45 Then Me.[2nd Week...

Thanks for responding!! There is another date field in the report and it is working fine. It is a date where an employee missed time. It is entitled date and the date is entered. No, the date is not being stored in the table. I think the problem is with the query.