Search results

Thanks for the suggestion it worked like a charm, didn't even tried to put nz() on the formula of the Balance field. Actually the status is already in one of the field of the table and what I did is I made a separate query for each of the status to show in the column because if I am going to...

Hello everyone, I have a question regarding counting of text values base on their status and using that result to a calculation. Say, I have a table of Demand of Positions, wherein, I have a specific Job Title for a certain Department that have number of workers needed (demand quantity) and a...

Thank you for the suggestion. I will rethink the structure before doing it in access.

I am very sorry for the dumb explanation on what I realized on the first structure. On my First structure the problem is it doesn't give me the feature to update the department and the Job title as it is already included in the tblPost. What I did in the new structure is that for the sake of...

Hello to everyone, After trying the design that I posted before, I realized that it will not work on my needs, finally I made a new structure for me to again test but before I create a table and construct it in access I just wanted to ask for suggestions again in this design. Please take a...

- Thank you for the info I will definitely remove that table. - I did not include any reference number or control number since what I am receiving from the agency is plain resume of candidates no control number written from the agency.

Hi plog or to anyone here that can check the attached photo, this is the revised tables that I made already in access. Can you please give me some advice to things that I need to change or to what would be the problem in the future. TIA

Thank you for the reply. I don't have any idea about that since I am not well verse in access vba not like excel. But I'll definitely try it for my learning. Thank you very much

Hello everyone, Just wanted to ask how can I enable this kind of setting, I have a Departments table, the departments table have a sub department, it is connected as, for each department it can have many sub department but sub department can only have one department. So basically, I have an...

Thank you for your advise. I will change the design and create the tables then test drive it then I'll post here if there are any issues. Thanks again!

Okay, I get your point. So the point in separating the candidate info is to allow the candidate to apply for another post? am I correct?

In my first design, I separated the candidate info and also the progress of the candidate but the thing is the candidate will just have one progress in his deployment that is why I change it and include one table for their updates. If I am going to break the candidate info from that table? do...

- Yes there is no need to attached the contact person from that agency to the candidate since the purpose of the agency is just to track how many candidates have been selected in that recruitment agency - I already think about that before since this would be just a simple database, I prefer to...

Thanks for the comment. I will delete those tables and replace it with a look up field. Anyway, what would be the few questions that you might want to ask?

Hello everyone, I would like to seek help from guru's here in the forum. I am currently working on a Database design which is base from an excel file that I have been using, the file was just handed over to me. So the purpose of this database is mainly, The recruitment tracking database...

Yeah, actually the access file that I have is based from the Asset Tracking Database. I'll study the access file that you mentioned and also I need to have a book in learning access. Thanks for the info.

Any ideas that you can share? can you I see the database that you have even just a screen shot? the tables relationship? Thanks in advance

Hi everyone I am working with my database design and I stumbled upon this scenario. My database that I am working on is an equipment database which means some of the equipments will have one operator and some will not, now my problem is how can I have the option if the equipment doesn't have any...

lol how can I attach the zip file. I'm pressing the attachments icon or the manage attachments but nothing happens.

Actually I made the design using MS Excel I just listed all the fields together with the data types I'll try to finish it using a data modeling tool today. Thank you.