Search results

Just for clarification: The "assigned employees" should be "Number of assigned employees". Any assistance that can be given would be apprceiciated more then you will know. Donations can possibly be considered depending on the level of assistance given.

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

I will never claim to be an expert on anything. By the time I master something, another product comes along to replace the previous version. Looking at this update query is awesome. I like this tool and it will absolutely be useful, but I dont believe this is going to accomplish what I am...

In my defense though, I used google to get this far.... At a glance, I cant even believe I didnt know how to use this type of query. This seems to be the exact answer I was looking for. I cant be 100% sure until I have played with it for about....oh say 6 years.......but in the meantime I...

By the way, I got a real kick out of the link you posted. Myself and the co-workers cant stop laughing.

Yes indeed it is. Will look into it some more and post here if/when I achieve the desired results.

I dont know where to look at the "Update Query". I am sure that this database isnt completely normalised. I am still somewhat of a "rookie". From my research I have determined that my database is best qualified at best as 2NF...perhaps 3NF...meaning that situationally, with the complexities...

That is exactally what I am trying to do. (=

Just finished reading your article. I am not very good with VBA. In fact I just finished a 2 day SQL Querying course last week and my ears are still wet from it. With that said, I did do something of the sorts that you article suggested.......I used queries with the 'Like' criteria to sort...

Attached is an sample extracted from my database and converted to Excel. This table shows my fields in columns with the cooresponding value. Maybe that is my problem? I am trying to set this table up as a spreadsheet, which reads across rows as well as columns?

The entire field has multiple default values as each Work area has a different "pick standard"

I'm sorry. I don't quite understand. Where is the "Default Value property" located at? How do you create an "UPDATE" query?

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

I dont think it is either. The 87 forms are representative of the 87 different work areas. Each form records their Division, the four shift supervisors, staffing information, performance standards, work capabilities, etc. I wanted a seperate place for each supervisor to go to record their...

Thats what I am attempting to do, but I dont think I am doing it right. I have made the other tables into "Lookup" in which a user can select from a list (which is in the base table). However, when it comes to performance standards and number of employees assigned, I only want the relevant...

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

Awesome. Thanks for the education.

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 FIGURED IT OUT! It just came to me. I have the form looking up the value from a query. However, that query is not linked to my standards table, so therefore it CANNOT look up the value of 'EDC Racks DR' because there is no reference to that field!!!! New day. Fresh mind! Thanks...

Really didnt need a query as the table isnt that big. I dont have 2007 Access either. I think it is something very simple. I have a fresh mind today and I am going to try to catch what is wrong here without wasting any more of your time. I appreciate your assistance.