Search results

I am looking for assistance in setting up the structure and relationships for my database. I have a screenshot of the current relationships and all relevant available. FIXED (“Look Up” DATA): (Meaning data that remains consistent and will rarely change) Value Streams- 6 Different Value...

The theory is simple, but the issue has been racking my brain for days. I have a table named STANDARDS with multiple fields. To include but not limited to: "WrkArea" "Picks" I have a table named ATTENDANCE with multiple fields. To include but not limited to: "AttenDate" "PickStan" I want...

Please bear with me as I attempt to explain this issue. I know most of you are far more intelligent than I am, and am hoping I can find the right answer here, as many of you have been very helpful in educating me over the years....I feel I should be paying you tuition: Background: I am...

Is there a way (perhaps a Macro) that I could enable a scenrio in which a user enters a value into a form, and that value automatically becomes the default value for that form for every entry made thereafter? I am an intermediate access user who is a novice at VSA. I normally develop...

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

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

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

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

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