Search results

It is the wrong value because it should be returning the value of "11" but it is returning a "6" instead. For trouble shooting I looked for every instance in that table where the number "6" was. It appears a few times, but nothing that would link it to 'EDC Racks DR'

Awesome. I am now getting a value, but it is the wrong value. Any common mistakes that I could be making?

Still reviewing it. Have tried combinations of the formula. here is the exact formula: =DLookUp("Picks","Standards","Work Area=EDC Racks DR") "Picks" is the Field Name "Standards" is the Table name that the field "Picks" is in "EDC Racks" is the Field Name that the value is located...

Actually, I read that entire article at least 7 times before even posting here. I try to research my questions myself prior to asking on these boards. Maybe I am just going blind. I have been working on this project for a month now, and after awhile I am just mush. You answered a previous...

I am attempting to write a DLookup function but am getting an ERROR in return. Can someone tell me what I am doing wrong? Essentially I want the Value in one field automatically returned from the value of another field from another table. This way if the source data ever changes, it will be...

By the way, I am running Access 2010, if it matters.

I have created a calculated field in a table. The field calculation expression is as follows: [KA Direct Labor In]*[Pack Standard]*[KA Available Hours]+[KA OT Productive]. Basically I am reporting capabilities: However, If the field [Pack Standard] value is ZERO than I want to return a Zero...

Found the answer. DLookup. Thanks

Is it possible to automatically insert a value from a previous record into a different field in a new record through a query? Through my research I have found it is possible to do this if it is in the same field, but havent been able to find the answer for a different field. If so, can...

One more thing: The Case Open field is set for the Criteria of Like 'Yes'

I have a field which indicates whether it is an open or closed case. In this instance it is not important to seperate the closed cases. I am only interested in creating the reports for all Open cases. My fields in this query are CaseOpen? (Self Explaintory) PayPlan (Self Explaintory) Site...

I am looking for some help writing a formula. Briefly, I have "X" amount of employees who are on "Light Duty". I would like to create a report which shows (by bargining unit) who has been on Light Duty for Over a Year, 91 days to a year, or 90 days or less based on their "Start Date" which I...

I have been working on this project for awhile and have racked my brain constantly trying to decide how to best set up these relationships. I know the answer is so simple, but I cannot seem to grasp it. First and foremost, in no way will I claim to bean expert (or even really good) with...

Excellent. The above posts really helped a lot. Thanks for the assistance and the education. DJ

Thanks for both the welcome and the advice. Wouldnt the instructions you gave allow users to enter numbers ending in other than .00, .25, .50, or .75? For example, Access would allow them to enter 12.45 using these settings? I am creating a database to track OT hours used throughout a...

I need help! I am trying to create a validation rule for a number data type field. My rule would only allow entries to end with the following: .00, .25, .50, .75 The number before the decimal could range anywhere between 1 and 18. Essentially, I only want users to be able to enter data...