Search results for query: *

Thank you everyone for your thoughts...my problem has been solved. For those who are interested, I used a double-negation method to return the results I was looking for: The "double-negation" method use the logic of 2 negations: 1. First negation: Find the Employees that do not meet the...

I think, (and I could be wrong) that the LevelReq field is ok in just the tblJobLevelReq because there are relationships between tblJobLevelReq and the other tables you mentioned. I'm pretty sure, to keep the data normalized, I need to keep those seperate...again, I could be wrong. Thanks for...

Yes and no :) The tblJobLevelReq already contains all of the levels for each job, by competency. ([LevelReq], [JobID], [CompID]) What I need is the number of employees that meet ALL of the competency levels for a given job. I can pull the # of employees that meet each individual competency...

Yes, each job has several competencies required at varying levels. I can make the comparison [Level]>=[LevelReq] for each competency and can count the number of [EmpID]s that meet that criteria, by competency. What I need are only the results where [Level]>=[LevelReq] for ALL of the...

Good morning all, The query I am trying to create is a doozy and I could really use some assistance. Background Jobs in my office have a list of competency levels that an employee must achieve through testing in order to apply for a position. The goal of this query is to provide a count of...

Have you used the Database Splitter to split the database? If not, that's probably your answer. Each user can then have a front end on their own machine and you can store the backend (data part) in the shared drive.

I'm not 100% sure on this as I'm fairly new to Access, but couldn't you just adjust the join properties in your query between the two tables to include all records form t_issue and records from Department where both are equal? (Not sure if that would be called a Right or Left Join, but...

I can't seem to solve this issue...so I'll let it be. Thanks for the time. V

You are correct....again (haha) subfrmJobLevelReq is linked by JobID V

So much for clarification, I apologize...I made and error in the table structure. The tables look like this: tblEmployees EmployeeID(PK) FirstName LastName JobID (FK to tblJobs) UnitID (FK to tblUnits) tblEmployeeLevel EmployeeID (Dual PK) CompID (PK with EmployeeID and FK to...

Thanks again for the response, I'll try to clarify. The main form is the employee form. It is bound to tblEmployees which contains the following data: tblEmployees EmployeeID (PK) FirstName LastName This main form contains a number of subforms, one for their current unit, manager and...

Hi Duane, Thanks for the response. I must be missing something. The Record Source of the subform that I want formatted is currently set to tblEELevel (so that the values can be editted on the form). How would I add tblJobLevelReq to the record source while still maintaining the ability to...

Good morning all, I think I'm close to solving this puzzle but there's just one piece missing. I have a main form with a two continuous subforms on it. The subforms refer to required levels that an employee must have in different "competencies" in order to fill a certain job. So jobs have...

Many thanks to you both. I think I've learned more in this single thread than I did in the last Access course I took :) V

Hi PHV, Thanks for the tip. I had to modify it a little: Your Filter property (set in the AfterUpdate event procedure of cboFiscal): Me.Filter = "[yourDateField] Between #" & Me!cboFiscal.Column(2) & "# And #" & Me!cboFiscal.Column(3) & # ...but it works well. Just as an aside, if I wanted...

Hello again, I've got it working now... Sometimes its the simplest little things. When I added Between DLookUp("[endDate]","tblfiscalyrs","fiscalID=" & Forms!frmStartup!cboFiscal) And DLookUp("[startDate]","tblfiscalyrs","fiscalID=" & Forms!frmStartup!cboFiscal) to the filter, I forgot to...

Hi Duane, Thanks for the prompt reply. While testing this, I have simply been clicking the apply filter button on the toolbar to attempt to apply the filter. The plan was to add a: Me.FilterOn = True later. You are correct that the filter is looking up values from a combo box on the main...

Good morning all, I can't seem to find the error in this, I'm hoping someone can shed some light. I am trying to filter a form to only show entries from this fiscal year. I have a fiscal year table that I am doing a DLookUp on. When I try to apply the filter, I get the following error...

Well done sir. Thank you much...works like a charm. :) D

Hey kvj1611, Thanks for the quick response. I recognize the inefficiency of rekeying data, but (without going into too much detail), in this case there is some analysis required as the data is keyed, so I'd have to look at each entry whether I keyed it myself or not. As for the text box...