Search results

Thank you for taking the time to respond. I did in an effort to make it sane, renamed the tables, queries, and forms with suffices to make it easier. I've also redid a bunch of fields for the same reasons. Wish I had a copy of the before. Fields named like Exp1, Exp2, Exp18. Should also...

Thank you. I will give this a go when I get back. Much appreciated.

Correct path I'm going?

I'm going to try and sneak down and post a stripped db

Oh I didn't think of it like that.

It would be a many to many, except I want to track when they were employed in that area. So would that not make it one-to-many? It's unlikely there would be users with the same start and end dates for employment areas

Essentially. If Bob had employment is Plumbing entered against them in error. The option to select that plumbing employment for Bob to be removed exists. I probably misused the term delete record.

I will sanitize the data and post a stripped down dB later when I can.

Only if a record was added to the wrong person, just that employment timeline, not employment area completely. Option to delete the record to be able to place it in its proper location.

The 1st one. Here are/is the work areas where employee x has worked. ID Employee Area Year I would normally have a subform and just tell the parent and child relation, but it doesn't fit the template well.

I had a long self discussion. I don't think it would be a many to many, I say this the employment area is per employee is by each employees experience. If I didn't want to track their start and end dates, then I would consider having a junction table for a many to many. 1 employee can have...

I can try in the morning, will have to sanitize the data.

Good day everyone. I thought I had everything set correct, but it would seem not. I am trying to have a table, where we can track what area's of the building people were employed. Many employment areas to one employee. Problem being, when click on the "Area of Employment" and the form...

Thank you for the replies. In a fit of frustration, I went and redid the queries and everything in the last hour or two, lost track of time. And tried again. This is working! =(DLookUp("Count_TRADE","qry_EMPTY_HRMS_COUNT","[TRADE] = 'AVN'")/DLookUp("Count_MOC","qry_HRMS_COUNT_REG","[MOC] =...

Good day AWF, I've managed to get this to work using DCount, but realized that it's starting to bog down as it has to go through the whole recordset, which will only grow. So I've got the queries working fine, and by themselves the 2 DLookups, give out the proper filtered counts. But when I...

That worked perfectly! Thank you very much. I'll be adding this to my quick referance guide!

Hello AWF, been a while, but still been lurking. I've been down so many combinations that I've lost where and what I did. I have a master list of employee positions. Not all positions are filled by the employees. I wish to count the number of blank positions where an employee is not in to...

For sure. Whats your email so I can get a hold of you (on the DIN hopefully).

Hey. Let me know how I can help.

It has been used for years now (I'm assuming it's still in use). I am not longer with that work place, but I do have a copy of the database.