Search results

Thanks, I will spend time trying to get it to work this afternoon and if I have questions, I will ask for your help again!! You guys are so amazing!

Thanks for your replies. The After update sounds complicated to me, so I will have to try to figure it out. Would you put that in the control source of the text box?

I have a Machine table and I have a Machine type table. Currently they are being selected by a drop down list. I thought that was fine, no problem, but I was asked to make the machine type automatically fill when the Machine name is entered.

I have a form with several fields. Two of the fields are [Machine] and [Machine Type]. Instead of typing in the machine type, the manager wants it to be automatically filled when the machine name is entered. I want to do an IIF statement in the control source, but I can't get it to work. I...

Sorry I didn't get back sooner. I have been away from my desk most of the day. I worked on the problem some more and I finally got it to work. I still don't know what I was doing wrong. But thank you very much for your help!

I went in and added the formula to the unbound text box and it worked but when I went to the next record I received an error message saying I must enter a value in the weekending date field. What did I do wrong? Thanks!

Thanks! - I will research because I don't know exactly was a cascading combo box is. I appreciate your response:o

Thank you so much for taking the time to answer. So are you saying I can't have the date field calculate the weekending field on the form? If I typed in what you suggested in the date field it would change it to the weekending date in the date field? Thanks,

I was asked to create two new fields on a form and I don't know if it can be done. One of the fields is Client and the other is Tag Type. I was asked if when a client's name is entered in the Client field is it possible that just the tag types be listed to select in a drop down list for that...

I have a form which was created from a table. In the form I have a Date field and a Weekending Date field. I would like to automatically calculate the weekending date from the date that is entered in the date field. Should I have created the form from a query? I have searched for an answer...

I have a form that was created from a table. I have two fields, Date and Week ending date. I would like the week ending date to be automatically calculated when the date is entered in the Date field. Should I have used a query to create the form? I have read the posts and I can't seem to...

It has been several years since I have I had to create a report and my memory has failed me miserably. Anyway, I am trying to create a report where several of the totals are calculated using other columns. The total is arrived at by calculating two other columns, i.e. Total waste divided by...

I have a large report that runs a six weeks average based on the last six weeks of production. Our fiscal year starts November 28th and our weeks starts on Monday. I have used the following format to start the week on Monday Week1: (DatePart("ww",[EntryDate],2)) To set up the fiscal year I...

Thanks for taking the time to respond. I will work on this report the next chance I get. I really appreciate all the help I get from the forum.

I have a report in Access 97 which is group by employee number and has the following totals for each employee SumOfStdHrs SumOfTotalUnits Units/Hr (this is calculated SumOfTotalUnits/SumOfTotalUnits Goal (I enter this number weekly) 85% (This is calculated...

I was too happy too soon! When reviewing my report and doublechecking my numbers, I realized that again if the production entry didn't have a matching error entry, the record didn't show up and the same for the error side. When I created the queries joining with the date table, all entries...

Thanks for your reply. I did try the date table last night and it worked great. I was able to create the report I needed. In answer to your question concerning having an error for a matching production record, in some cases the cartons aren't checked for errors until the next day and that...

Thanks for your reply. Actually the date fields are DateEntry and DateAudit. I do have the sum of the errors. The problem I have is joining the two queries. They both have EmpID and they both have date fields. BUT, they may not have the same dates(or week #s) in both queries and if there...

I have been reading all the threads on joining queries, right joins, left joins, etc., but I am having problems understanding. I have two queries. Query #1 Week # Dept Empl ID Name Std Hrs Earned Hrs Total Units Query #2 Week # Empl ID Total Errors The joins are Week # and Empl ID. The...

Actually, it is three queries - see attached file